You are about to run a complex SQL query on a multi-terabyte dataset in BigQuery. Because BigQuery charges per byte processed, you want to estimate the cost of the query BEFORE you actually run it.

Which TWO methods can you use to find out how much data the query will process? (Select TWO)

Answer options:

Look at the query validator in the BigQuery web UI.

Run the query and check the Cloud Billing report.

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

Export the table to Cloud Storage and check the file size.

Use the GCP Pricing Calculator to simulate the query.

How to approach this question

Identify the built-in BigQuery features (UI and CLI) that estimate query size without execution.

Full Answer

Look at the query validator in the BigQuery web UI., Run the bq query command with the --dry_run flag.

BigQuery provides two primary ways to estimate query costs before execution. In the Cloud Console UI, the query validator (green checkmark) displays the estimated bytes processed. In the CLI, appending the `--dry_run` flag to the `bq query` command will return the same estimate without executing the query.

Common mistakes

Thinking the Pricing Calculator can parse SQL queries to estimate data processed.

Question 37 All questions Question 39

Practice the full GCP Associate Cloud Engineer Practice Exam 3

50 questions · hints · full answers · grading

More questions from this exam

Q01You are starting a new project in Google Cloud and need to create a new GCP project and enable th...Easy Q02A new team member has joined your operations team. They need to be able to view all Compute Engin...Medium Q03Your company is migrating to Google Cloud. You currently manage all employee identities in an on-...Medium Q04Your development team is experimenting with new GCP services in a sandbox project. The finance te...Medium Q05Your company wants to perform complex, custom SQL analysis on their Google Cloud billing data to ...Easy

View all 50 questions →