Professional Cloud Architect · Free Practice Question Medium
Question 12
As a cloud architect, you are working with a cost-conscious client who regularly runs large, complex queries on BigQuery. They want to understand how they can estimate the cost of running a BigQuery query before they execute it to avoid unexpected expenses. Which of the following is the most suitable solution for this?
-
A
Use Google Cloud Pricing Calculator by entering the estimated amount of data processed by the query.
-
B
Use the BigQuery command-line tool's
bq showcommand to inspect the query. -
C
Preview the query in the BigQuery web UI, which displays an estimate of the amount of data the query will process.
-
D
Use Cloud Monitoring to estimate the cost based on previous query execution times.
Reveal correct answer
Correct answer: C
A.
The Google Cloud Pricing Calculator can help estimate costs for cloud services based on usage predictions, but it is not designed to predict the cost of individual BigQuery queries.
B.
The bq show command in BigQuery command-line tool is used to display information about dataset, table, or view, not to estimate the cost of a query.
C.
When you paste a query into the BigQuery web UI and click on the 'Compose Query' button without running the query, it will show an estimate of the amount of data that the query will process. You can then use this data to calculate the cost based on BigQuery's pricing.
D.
Cloud Monitoring is for monitoring resource usage and performance, not for estimating the cost of individual BigQuery queries.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
