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 Exam Professional Cloud Architect Topic 6 Question 100 Discussion

Actual exam question for Google's Professional Cloud Architect exam
Question #: 100
Topic #: 6
[All Professional Cloud Architect Questions]

Your company has a Google Cloud project that uses BigQuery for data warehousing on a pay-per-use basis. You want to monitor queries in real time to discover the most costly queries and which users spend the most. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: C

https://cloud.google.com/blog/products/data-analytics/taking-a-practical-approach-to-bigquery-cost-monitoring


by Tegan at Jan 11, 2025, 12:22 PM

Limited Time Offer

25%

Off

Get Premium Professional Cloud Architect Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Jacki
2 months ago
Option C, huh? I guess they're really trying to squeeze every penny out of our BigQuery usage. Better keep those queries lean and mean!
upvoted 0 times
...
Vallie
2 months ago
Option D? More like Option 'Doh!' Am I right? Someone's been drinking too much cloud Kool-Aid.
upvoted 0 times
Art
19 days ago
D) In the BigQuery dataset that contains all the tables to be queried, add a label for each user that can launch a query. Open the Billing page of the project. Select Reports. Select BigQuery as the product and filter by the user you want to check.
upvoted 0 times
...
Bernardo
20 days ago
C) Activate billing export into BigQuery. Perform a BigQuery query on the billing table to extract the information you need.
upvoted 0 times
...
Shawnda
1 months ago
B) Create a Cloud Logging sink to export BigQuery data access logs to BigQuery. Perform a BigQuery query on the generated table to extract the information you need.
upvoted 0 times
...
Jaime
2 months ago
A) Create a Cloud Logging sink to export BigQuery data access logs to Cloud Storage. Develop a Dataflow pipeline to compute the cost of queries split by users.
upvoted 0 times
...
...
Arlene
2 months ago
I'd go with Option B. Keeping the logs in BigQuery just makes sense - no need to export them anywhere else. Efficient and straightforward.
upvoted 0 times
...
Marvel
3 months ago
Option A gets my vote. Dataflow can crunch the numbers and give us the insights we need. Plus, Storage is much cooler than BigQuery, right?
upvoted 0 times
...
Eric
3 months ago
Option D is way too complicated. Who has time to mess with all those labels and Billing reports? No thanks!
upvoted 0 times
Quentin
2 months ago
B) 1. Create a Cloud Logging sink to export BigQuery data access logs to BigQuery. 2. Perform a BigQuery query on the generated table to extract the information you need.
upvoted 0 times
...
Rosalind
2 months ago
A) 1. Create a Cloud Logging sink to export BigQuery data access logs to Cloud Storage. 2. Develop a Dataflow pipeline to compute the cost of queries split by users.
upvoted 0 times
...
...
Ria
3 months ago
Option C looks good to me. Tapping into the billing data should give us the details we need on query costs and user activity.
upvoted 0 times
Rasheeda
2 months ago
2. Perform a BigQuery query on the billing table to extract the information you need.
upvoted 0 times
...
Beckie
2 months ago
C) 1. Activate billing export into BigQuery.
upvoted 0 times
...
...
Deeanna
3 months ago
I'm not sure, I think option B could also work. Exporting BigQuery data access logs to BigQuery and performing a query on the generated table might provide the information we need.
upvoted 0 times
...
Charolette
3 months ago
I think Option B is the way to go. Exporting the logs directly to BigQuery makes the data more accessible for querying.
upvoted 0 times
Joesph
2 months ago
Let's go with Option B then. It's a straightforward solution to analyze costly queries and user spending.
upvoted 0 times
...
Katlyn
3 months ago
I agree, it seems like the most efficient way to monitor queries and track user activity.
upvoted 0 times
...
Paulina
3 months ago
Option B is a good choice. Exporting logs to BigQuery will make it easier to extract the information we need.
upvoted 0 times
...
...
Sabine
3 months ago
I agree with Lacey. Option A seems like the most efficient way to monitor queries in real time and identify the most costly queries and users.
upvoted 0 times
...
Lacey
3 months ago
I think option A is the best choice because it involves exporting BigQuery data access logs to Cloud Storage and developing a Dataflow pipeline to compute the cost of queries split by users.
upvoted 0 times
...
Lavonna
3 months ago
Option A seems the most comprehensive approach to monitoring BigQuery queries and costs in real-time.
upvoted 0 times
Daisy
2 months ago
Yes, it would definitely help in identifying the most costly queries and which users are spending the most.
upvoted 0 times
...
Oren
3 months ago
I agree, creating a Cloud Logging sink to export BigQuery data access logs to Cloud Storage and developing a Dataflow pipeline sounds efficient.
upvoted 0 times
...
Gayla
3 months ago
Option A seems the most comprehensive approach to monitoring BigQuery queries and costs in real-time.
upvoted 0 times
...
...

Save Cancel