You have 1000 GB of user analytics data stored in BigQuery and need to run a query that is expected to return a large number of records. Before executing the query, you wish to estimate its cost under on-demand pricing. What is the best approach to achieve this?

Real Exam

Execute a select count (*) query to estimate the number of records your query will process, then use the Pricing Calculator to convert this row count into a cost estimate.*

10.3%

Perform a dry run query via the command line to estimate the bytes read by the query, then use the Pricing Calculator to translate this byte estimate into a cost.

72.4%

Switch to Flat-Rate pricing temporarily for this query to estimate the cost, then revert back to on-demand pricing.

3.4%

Conduct a dry run query using the command line to estimate the bytes returned by the query, then apply the Pricing Calculator to convert this byte estimate into a cost.

13.8%

Google Associate Cloud Engineer

Get started today

Comments

You have 1000 GB of user analytics data stored in BigQuery and need to run a query that is expected to return a large number of records. Before executing the query, you wish to estimate its cost under on-demand pricing. What is the best approach to achieve this?