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.

How to approach this question

Identify the BigQuery feature that estimates query costs without executing them.

Full Answer

C.Use the BigQuery query validator in the Cloud Console or use the --dry_run flag in the bq CLI.✓ Correct

BigQuery charges based on the amount of data processed. You can perform a 'dry run' of a query (via the UI validator, API, or `bq query --dry_run`). This returns the exact bytes processed without executing the query, allowing you to calculate the exact cost beforehand.

Common mistakes

Assuming you have to run the query to find out the cost.

Question 36 All questions Question 38

Practice the full GCP Associate Cloud Engineer Practice Exam 2

50 questions · hints · full answers · grading

More questions from this exam

Q01Your company is migrating to Google Cloud and needs to establish a resource hierarchy. You have t...Easy Q02You are managing access to a GCP project. You need to grant 15 developers the ability to view Com...Medium Q03You have created a new GCP project using the Cloud Console. You want to deploy a Cloud Function u...Easy Q04Your startup has a strict monthly cloud budget of $500. You want to be notified immediately if yo...Easy Q05Your finance team wants to perform complex SQL analysis on your GCP billing data to understand co...Medium

View all 50 questions →