Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
When you need to run a query on a large dataset stored in BigQuery and anticipate a substantial amount of data to be returned, what is the best method to estimate the cost of the query?
A
Using the command line, apply the --dry_run option in BigQuery to find out the number of bytes read, then utilize the price calculator to estimate the cost.
--dry_run
B
Using the command line, apply the --dry_run option in BigQuery to find out the number of bytes returned, then utilize the price calculator to estimate the cost.
C
Using the command line, apply the --dry_run option in BigQuery to find out the time taken, then utilize the price calculator to estimate the cost.
D
Using the command line, apply the --dry_run option in BigQuery to determine the total amount of table data in bytes, assuming a full scan, then utilize the price calculator to estimate the cost.