Google Exam Professional Cloud Database Engineer Topic 3 Question 49 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam

Question #: 49
Topic #: 3

[All Professional Cloud Database Engineer Questions]

Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day. The application team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?

AIsolate the data analysts and operations user groups to use different Bigtable instances.

BCheck the Cloud Monitoring table/bytes_used metric from Bigtable.

CUse Key Visualizer for Bigtable.

DAdd more nodes to the Bigtable cluster.

Show Suggested Answer

Suggested Answer: C

https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#disaster_recovery

by Howard at Dec 07, 2024, 03:14 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Karol

21 hours ago

I'm going to go with the Key Visualizer. It's the most targeted tool for identifying data skew or hotspots, which sounds like the likely culprit here.

upvoted 0 times

...

Delsie

8 days ago

Isolating the user groups is an interesting idea, but it feels like overkill for this scenario. I'd try the Key Visualizer and Bigtable metrics first before resorting to that.

upvoted 0 times

...

Yolando

11 days ago

Definitely check the Bigtable metrics first to see if the table is hitting any resource limits. That could explain the daily performance spike.

upvoted 0 times

...

Isadora

13 days ago

The issue seems to be isolated to the new cohort of pilot users, so I'd start by checking the Key Visualizer to see if there's any hot-spotting or uneven data distribution causing the performance degradation.

upvoted 0 times

...