Answer-first summary for fast verification
Answer: Use the command line to run a dry run query to estimate the number of bytes read. Then convert that bytes estimate to dollars using the Pricing Calculator.
The correct answer is B. Under on-demand pricing, BigQuery charges for queries based on the number of bytes processed. Running a dry run query using the command line will estimate the number of bytes read by the query. This estimate can then be converted to dollars using the Pricing Calculator, providing an accurate cost forecast. Options A, C, and D do not provide an accurate estimate of costs based on bytes read.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are planning to execute a crucial query in Google BigQuery and anticipate that it will generate a substantial number of records. To manage your budget effectively, you need to estimate the cost of running this query under the on-demand pricing model. How should you approach this task?
A
Arrange to switch to Flat-Rate pricing for this query, then move back to on-demand.
B
Use the command line to run a dry run query to estimate the number of bytes read. Then convert that bytes estimate to dollars using the Pricing Calculator.
C
Use the command line to run a dry run query to estimate the number of bytes returned. Then convert that bytes estimate to dollars using the Pricing Calculator.
D
Run a select count (*) to get an idea of how many records your query will look through. Then convert that number of rows to dollars using the Pricing Calculator.
No comments yet.