A data analyst is about to run a complex SQL query on a multi-terabyte BigQuery dataset. They are concerned about how much the query will cost and want to estimate the data processed before actually executing it.

Which TWO methods can they use to estimate the cost? (Select TWO)

Answer options:

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

Look at the query validator in the Cloud Console UI before clicking Run.

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

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

Check the Cloud Billing export for the previous day.

How to approach this question

Identify how BigQuery provides cost estimates prior to execution.

Full Answer

BigQuery charges based on the amount of data processed (scanned). You can estimate this cost without running the query by performing a 'dry run'. In the CLI, you use `bq query --dry_run`. In the Cloud Console, the query editor automatically performs a dry run as you type and displays the estimated bytes processed.

Common mistakes

Believing that adding `LIMIT 10` reduces the cost. BigQuery is a columnar database; it scans the entire column regardless of the LIMIT clause.

Question 37 All questions Question 39

Practice the full GCP Associate Cloud Engineer Practice Exam 7

50 questions · hints · full answers · grading

More questions from this exam

Q01You are starting a new initiative and need to create a new Google Cloud project using the Cloud S...Easy Q02Your company is migrating to Google Cloud and wants to manage user identities centrally. They cur...Medium Q03You have just created a new Google Cloud project and want to deploy a containerized application u...Medium Q04Your finance team wants to perform complex SQL queries on your Google Cloud billing data to analy...Medium Q05You are managing a development project in Google Cloud. You want to ensure that you are notified ...Easy

View all 50 questions →