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 that the query will return a significant amount of data, 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 find out the total amount of table data in bytes, assuming a full scan, then utilize the price calculator to estimate the cost.