GCP ACE · Question 37 · Domain 4.4: Managing storage and database solutions
You are about to run a complex SQL query in BigQuery that joins several multi-terabyte tables. You are concerned about how much this single query will cost.
How can you find out the exact amount of data the query will process BEFORE you run it?
Answer options:
Run the query and check the Billing Dashboard afterward.
Use the Pricing Calculator and manually estimate the table sizes.
Use the BigQuery query validator in the Cloud Console or use the --dry_run flag in the bq CLI.
Set a custom quota on the project to block queries over 1 TB.
50 questions · hints · full answers · grading
Expert