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 Professional Cloud Architect (PR000213) Exam - Topic 9 Question 48 Discussion

Your BigQuery project has several users. For audit purposes, you need to see how many queries each user ran in the last month.
C) Use 'bq show' to list all jobs. Per job, use 'bq Is' to list job information and get the required information.
A) Connect Google Data Studio to BigQuery. Create a dimension for the users and a metric for the amount of queries per user.
B) In the BigQuery interface, execute a query on the JOBS table to get the required information.
D) Use Cloud Audit Logging to view Cloud Audit Logs, and create a filter on the query operation to get the required information.

Google Professional Cloud Architect (PR000213) Exam - Topic 9 Question 48 Discussion

Actual exam question for Google's Professional Cloud Architect (PR000213) exam
Question #: 48
Topic #: 9
[All Professional Cloud Architect (PR000213) Questions]

Your BigQuery project has several users. For audit purposes, you need to see how many queries each user ran in the last month.

Show Suggested Answer Hide Answer
Suggested Answer: C

https://cloud.google.com/bigquery/docs/managing-jobs


by Josphine at May 09, 2022, 04:01 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Hershel
7 months ago
Not sure if C will give us the full picture.
upvoted 0 times
...
Matthew
7 months ago
Wait, can we really get all that info from Cloud Audit Logging?
upvoted 0 times
...
Raul
8 months ago
A seems too complicated for this task.
upvoted 0 times
...
Miles
8 months ago
I think D is better for detailed audit logs.
upvoted 0 times
...
Aileen
8 months ago
Option B is the quickest way to get user query counts!
upvoted 0 times
...
France
8 months ago
I vaguely recall that 'bq show' and 'bq ls' were mentioned in our notes, but I’m not sure if they provide the user-specific query counts we need.
upvoted 0 times
...
Curtis
8 months ago
I feel like we did a similar question where we had to analyze user queries. Option A seems like it could work, but I’m not confident about using Data Studio for this.
upvoted 0 times
...
Jeannine
8 months ago
I'm not entirely sure, but I remember something about using Cloud Audit Logging. Option D might be the right approach for tracking user activity.
upvoted 0 times
...
Glenn
8 months ago
I think option B sounds familiar; we practiced querying the JOBS table in class to get job details.
upvoted 0 times
...
Edna
8 months ago
Okay, I've got this. Field Update and Auto launched Flow are the two automated actions that can be part of the approval process. The other options are more manual.
upvoted 0 times
...
Scot
8 months ago
I thought PCR was a measure of total assets, but now I'm second-guessing myself. I definitely need to revisit those ratios we studied!
upvoted 0 times
...
Hassie
8 months ago
Okay, I've got a strategy here. I'll start by considering the specific details - a wet floor causing a fall and injury in the ICU. That points to potential issues with housekeeping or safety protocols.
upvoted 0 times
...

Save Cancel