Google Associate Cloud Engineer Exam - Topic 11 Question 5 Discussion

Actual exam question for Google's Associate Cloud Engineer exam

Question #: 5
Topic #: 11

[All Associate Cloud Engineer Questions]

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?

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. Then convert that bytes estimate to dollars using the Pricing Calculator.

CUse the command line to run a dry run query to estimate the number of bytes returned. Then convert that bytes estimate to dollars using the Pricing Calculator.

DRun a select count (*) to get an idea of how many records your query will look through. Then convert that number of rows to dollars using the Pricing Calculator.

Show Suggested Answer

Suggested Answer: B

https://cloud.google.com/bigquery/docs/estimate-costs

by Veronika at May 07, 2022, 01:43 PM

Limited Time Offer

25%

Off

Get Premium Associate Cloud Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Jacklyn

4 months ago

I thought dry runs only estimate rows, not bytes?

upvoted 0 times

...

Karan

4 months ago

B is definitely the best option here!

upvoted 0 times

...

Tarra

4 months ago

Wait, can you really switch back to on-demand after flat-rate?

upvoted 0 times

...

Carin

4 months ago

I disagree, D seems more straightforward for a quick check.

upvoted 0 times

...

Anabel

5 months ago

B is the way to go! Dry run gives a solid estimate.

upvoted 0 times

...

Callie

5 months ago

I feel like option D is not the best choice since counting rows doesn't really give a good cost estimate. I think I’ll go with B.

upvoted 0 times

...

Shawna

5 months ago

I’m a bit confused about the difference between bytes read and bytes returned. I hope I can remember which one to use for the cost estimate.

upvoted 0 times

...

Sommer

5 months ago

I practiced a similar question where we had to estimate costs in BigQuery, and I feel like the dry run is definitely the way to go.

upvoted 0 times

...

Anika

5 months ago

I think I remember that using a dry run query can help estimate costs, but I'm not sure if it's option B or C.

upvoted 0 times

...

Danica

5 months ago

Option D looks promising to me. Disabling the interdigit timeout on the route pattern seems like it would solve the issue and allow the call to route out immediately.

upvoted 0 times

...

Dino

5 months ago

I'm a bit confused by the question. Can someone explain the difference between business rules, transform maps, and reconciliation rules?

upvoted 0 times

...