Ultimate access to all questions.
Answer-first summary for fast verification
Answer: Use `bq query --dry_run` to determine the number of bytes read by the query. Use this number in the Pricing Calculator.
The correct answer is to use `bq query --dry_run` to estimate the bytes read by the query, then use this figure in the Pricing Calculator for an annual cost estimate. This method aligns with Google Cloud's best practices for pricing queries, which bill based on bytes read. Options A and D are incorrect because they suggest using `gcloud` commands, which are not suited for BigQuery operations. Option B is incorrect as it misapplies the `gcloud query --dry_run` command, which is not the recommended tool for BigQuery cost estimation.
Author: LeetQuiz Editorial Team
No comments yet.
To estimate the annual cost of a BigQuery query scheduled to run nightly, which approach should you take?
A
Use bq estimate to determine the amount billed for a single query. Multiply this amount by 365.
B
Use gcloud query --dry_run to determine the number of bytes read by the query. Use this number in the Pricing Calculator.
C
Use bq query --dry_run to determine the number of bytes read by the query. Use this number in the Pricing Calculator.
D
Use gcloud estimate to determine the amount billed for a single query. Multiply this amount by 365.