Practice Test 2 | Google Cloud Certified Associate Cloud Engineer | Dumps | Mock Test
Your company is hosting 10TB of customer data in BigQuery. The CTO of company has decided to use this data and build some analytics on top of data which they have. At the end of first month there was a huge spike in the bill due to use of BigQuery and CFO was not happy with the same. He has asked you to cut down the cost. How can you achieve this?
A. Use GROUP BY clause.
B. Use composite keys to query the data.
C. Instead of using SELECT *, query only required columns.
D. Use JOINS in the query to fetch data.
Explanation:
Answer C
Option C is correct: By limiting the number of columns to required ones you will be able to reduce the amount of data processed by BigQuery thus saving cost.
Option A is incorrect: Grouping query result does not help in reducing cost. It just groups result depending on the column specified.
Option B is incorrect: Composite key will not help in reducing cost. This is only used to create unique records in a table.
Option D is incorrect: JOINS are used when you are querying data from more than one table.
Link:
https://cloud.google.com/bigquery/pricing
Comments are closed, but trackbacks and pingbacks are open.