You are about to run a complex SQL query in BigQuery that joins several multi-terabyte tables. You are concerned about the potential cost of this query.

Which TWO methods can you use to estimate the cost BEFORE executing the query? (Select TWO)

Answer options:

Use the BigQuery web UI (Console) which displays the estimated bytes processed before you click Run.

Run the query with a LIMIT 10 clause to test the cost.

Use the bq query command with the --dry_run flag.

Check the Cloud Billing export logs.

Use the Pricing Calculator to simulate the query execution plan.

How to approach this question

Identify the tools that provide query validation and byte estimation without execution.

Full Answer

Use the BigQuery web UI (Console) which displays the estimated bytes processed before you click Run., Use the bq query command with the --dry_run flag.

BigQuery charges based on the amount of data processed (bytes read). Before running a query, you can see the estimated bytes processed in the top right corner of the BigQuery Console UI. Alternatively, using the CLI, you can append the `--dry_run` flag to the `bq query` command. Both methods are free and do not execute the query.

Common mistakes

Believing that adding `LIMIT 10` reduces the cost of a BigQuery query.

Question 37 All questions Question 39

Practice the full GCP Associate Cloud Engineer Practice Exam 4

50 questions · hints · full answers · grading

More questions from this exam

Q01You have recently joined a new team and need to set up a new Google Cloud project for a developme...Easy Q02Your company uses Google Workspace. You need to grant a new developer, Alice, the ability to view...Medium Q03You have created a new GCP project and want to deploy a Compute Engine instance. However, when yo...Medium Q04Your startup has a strict monthly cloud budget of $500. You want to be notified via email when yo...Easy Q05Your finance team wants to analyze Google Cloud costs using standard SQL and build custom dashboa...Medium

View all 50 questions →