Topic 1 Question 15
You need to run an important query in BigQuery but expect it to return a lot of records. You want to find out how much it will cost to run the query. You are using on-demand pricing. What should you do?
Arrange to switch to Flat-Rate pricing for this query, then move back to on-demand.
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.
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.
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.
ユーザの投票
コメント(17)
B is Correct
👍 34Agents892020/05/01Correct Answers is (B):
On-demand pricing Under on-demand pricing, BigQuery charges for queries by using one metric: the number of bytes processed (also referred to as bytes read). You are charged for the number of bytes processed whether the data is stored in BigQuery or in an external data source such as Cloud Storage, Drive, or Cloud Bigtable. On-demand pricing is based solely on usage.
👍 33ESP_SAP2020/08/22- 正解だと思う選択肢: B
The correct answer is Option B. Running a dry run query using the command line can estimate the number of bytes read by the query, which can then be used to estimate the cost of running the query using the Pricing Calculator. To estimate the cost of a BigQuery query, you can use the
bqcommand-line tool to run a dry-run query.Option A: Arranging to switch to Flat-Rate pricing will not help you estimate the cost of running the query using on-demand pricing.
Option C: Estimating the number of bytes returned by the query will not give you an accurate estimate of the cost of running the query using on-demand pricing.
Option D: Estimating the number of rows that the query will look through will not give you an accurate estimate of the cost of running the query using on-demand pricing.
👍 4Buruguduystunstugudunstuy2022/12/29
シャッフルモード