You need to run an important query in BigQuery but expect it to return a lot of records. You want to find out how much it will cost to run the query. You are using on-demand pricing. What should you d

The correct answer is B. Use the command line to run a dry run query to estimate the number of bytes read.. On-demand pricing Under on-demand pricing, BigQuery charges for queries by using one metric: the number of bytes processed (also referred to as bytes read). You are charged for the number of bytes processed whether the data is stored in BigQuery or in an external data source such

Submitted by priya_blr· Mar 30, 2026Ensuring successful operation of a cloud solution

Question

You need to run an important query in BigQuery but expect it to return a lot of records. You want to find out how much it will cost to run the query. You are using on-demand pricing. What should you do?

Options

AArrange to switch to Flat-Rate pricing for this query, then move back to on-demand.
BUse the command line to run a dry run query to estimate the number of bytes read.
CUse the command line to run a dry run query to estimate the number of bytes returned.
DRun a select count (*) to get an idea of how many records your query will look through.

How the community answered

(16 responses)

B
94% (15)
D
6% (1)

Explanation

On-demand pricing Under on-demand pricing, BigQuery charges for queries by using one metric: the number of bytes processed (also referred to as bytes read). You are charged for the number of bytes processed whether the data is stored in BigQuery or in an external data source such as Cloud Storage, Drive, or Cloud Bigtable. On-demand pricing is based solely on usage. https://cloud.google.com/bigquery/pricing#on_demand_pricing

Topics

#BigQuery#dry run#cost estimation#on-demand pricing

Community Discussion

No community discussion yet for this question.

Full ASSOCIATE-CLOUD-ENGINEER Practice