Google Professional Data Engineer Exam - Topic 4 Question 6 Discussion

Actual exam question for Google's Professional Data Engineer exam

Question #: 6
Topic #: 4

[All Professional Data Engineer Questions]

You need to compose visualization for operations teams with the following requirements:

Telemetry must include data from all 50,000 installations for the most recent 6 weeks (sampling once every minute)

The report must not be more than 3 hours delayed from live data.

The actionable report should only show suboptimal links.

Most suboptimal links should be sorted to the top.

Suboptimal links can be grouped and filtered by regional geography.

User response time to load the report must be <5 seconds.

You create a data source to store the last 6 weeks of data, and create visualizations that allow viewers to see multiple date ranges, distinct geographic regions, and unique installation types. You always show the latest data without any changes to your visualizations. You want to avoid creating and updating new visualizations each month. What should you do?

ALook through the current data and compose a series of charts and tables, one for each possible
combination of criteria.

BLook through the current data and compose a small set of generalized charts and tables bound to criteria filters that allow value selection.

CExport the data to a spreadsheet, compose a series of charts and tables, one for each possible
combination of criteria, and spread them across multiple tabs.

DLoad the data into relational database tables, write a Google App Engine application that queries all rows, summarizes the data across each criteria, and then renders results using the Google Charts and visualization API.

Show Suggested Answer

Suggested Answer: B

by Emerson at May 06, 2022, 08:06 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

Karol

4 months ago

Not sure if Google Charts can handle all that data without lag.

upvoted 0 times

...

Lottie

4 months ago

Definitely going with B, it keeps things simple and efficient.

upvoted 0 times

...

Lenita

4 months ago

Wait, can we really handle 50,000 installations that quickly?

upvoted 0 times

...

Elfrieda

4 months ago

I disagree, D sounds more robust for handling large data.

upvoted 0 times

...

Vincent

5 months ago

Option B seems like the best choice for flexibility.

upvoted 0 times

...

Fletcher

5 months ago

I feel like option C could be too static since it involves exporting to a spreadsheet, which doesn't align with the real-time data requirement.

upvoted 0 times

...

Kiera

5 months ago

I'm not entirely sure, but I think creating a series of charts for every combination, like in option A, could lead to too much clutter.

upvoted 0 times

...

Ettie

5 months ago

I remember we discussed the importance of using filters for dynamic reports, so option B sounds like it could be the right approach.

upvoted 0 times

...

Merri

5 months ago

I practiced a similar question where we had to optimize report loading times. I think option D might be overkill for this scenario.

upvoted 0 times

...

Twila

5 months ago

Hmm, this seems like a tricky one. I'll need to think carefully about the implications of enabling My Domain.

upvoted 0 times

...

Rosalia

5 months ago

Replacing the SFP in slot fc2/12 seems like a bit of a long shot, unless we have some indication that there might be a hardware issue. I'll keep that in the back of my mind, but I think I'll focus on the other options first.

upvoted 0 times

...

Winifred

5 months ago

I've got a good feeling about this one. Based on my understanding of Prisma Cloud, I think the correct answers are BitBucket and CircleCI.

upvoted 0 times

...