Google Professional Data Engineer Exam - Topic 6 Question 17 Discussion

Actual exam question for Google's Professional Data Engineer exam

Question #: 17
Topic #: 6

[All Professional Data Engineer Questions]

Each analytics team in your organization is running BigQuery jobs in their own projects. You want to enable each team to monitor slot usage within their projects. What should you do?

ACreate a Stackdriver Monitoring dashboard based on the BigQuery metric query/scanned_bytes

BCreate a Stackdriver Monitoring dashboard based on the BigQuery metric slots/allocated_for_project

CCreate a log export for each project, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs, and create a Stackdriver Monitoring dashboard based on the custom metric

DCreate an aggregated log export at the organization level, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs, and create a Stackdriver Monitoring dashboard based on the custom metric

Show Suggested Answer

Suggested Answer: D

by Wilda at May 05, 2022, 04:04 PM

Limited Time Offer

25%

Off

Get Premium Professional Data Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Rossana

4 months ago

D sounds like overkill for just monitoring slots!

upvoted 0 times

...

Cherelle

4 months ago

A is too focused on bytes, not slots.

upvoted 0 times

...

Jeniffer

4 months ago

Wait, can we really create custom metrics like that?

upvoted 0 times

...

Jordan

4 months ago

I disagree, C seems more comprehensive.

upvoted 0 times

...

Reena

5 months ago

I think option B is the best for monitoring slots.

upvoted 0 times

...

Charlene

5 months ago

I’m a bit confused about whether we should focus on individual projects or the organization as a whole. I thought option B was about slots, but now I'm not so sure.

upvoted 0 times

...

Bulah

5 months ago

I think option C sounds familiar because we practiced creating custom metrics from logs, but I can't recall if it was specifically for slot usage.

upvoted 0 times

...

Markus

5 months ago

I remember we discussed something about monitoring metrics in BigQuery, but I'm not sure if it's about scanned bytes or slots allocated.

upvoted 0 times

...

Erick

5 months ago

I feel like we did a similar question where we had to choose between log exports and direct metrics. I wonder if option D is the right choice since it mentions organization-level aggregation.

upvoted 0 times

...

Sherman

5 months ago

SysTest is the tool I'm most familiar with, so that's probably what I'd recommend. It has a lot of features for unit testing and integrating with Dynamics 365.

upvoted 0 times

...

Adaline

5 months ago

I'm a bit unsure about the nuances of this question. The scenario provides a lot of details, so I'll need to carefully read through it and think about the PRINCE2 principles involved.

upvoted 0 times

...

Skye

5 months ago

I'm leaning towards "C" for script since that's where I remember defining the main flow of the IVR. Could be a tricky one though!

upvoted 0 times

...

Orville

5 months ago

I vaguely remember that the control limits can be derived from the average range, but I can't decide if it's closer to 3.423 or another option.

upvoted 0 times

...