Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Associate Cloud Engineer Exam - Topic 11 Question 5 Discussion

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?
B) Use 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.
A) Arrange to switch to Flat-Rate pricing for this query, then move back to on-demand.
C) Use 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.
D) Run 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.

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Jacklyn
9 months ago
I thought dry runs only estimate rows, not bytes?
upvoted 0 times
...
Karan
9 months ago
B is definitely the best option here!
upvoted 0 times
...
Tarra
9 months ago
Wait, can you really switch back to on-demand after flat-rate?
upvoted 0 times
...
Carin
9 months ago
I disagree, D seems more straightforward for a quick check.
upvoted 0 times
...
Anabel
9 months ago
B is the way to go! Dry run gives a solid estimate.
upvoted 0 times
...
Callie
10 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
10 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
10 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
10 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
10 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
10 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
...

Save Cancel