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
10 months ago
Not sure if C will give us the full picture.
upvoted 0 times
...
Matthew
10 months ago
Wait, can we really get all that info from Cloud Audit Logging?
upvoted 0 times
...
Raul
11 months ago
A seems too complicated for this task.
upvoted 0 times
...
Miles
11 months ago
I think D is better for detailed audit logs.
upvoted 0 times
...
Aileen
11 months ago
Option B is the quickest way to get user query counts!
upvoted 0 times
...
France
11 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
11 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
11 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
11 months ago
I think option B sounds familiar; we practiced querying the JOBS table in class to get job details.
upvoted 0 times
...
Edna
11 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
11 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
11 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