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 Database Engineer Exam - Topic 3 Question 49 Discussion

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?
C) Use Key Visualizer for Bigtable.
A) Isolate the data analysts and operations user groups to use different Bigtable instances.
B) Check the Cloud Monitoring table/bytes_used metric from Bigtable.
D) Add more nodes to the Bigtable cluster.

Google Professional Cloud Database Engineer Exam - 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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Justine
7 months ago
Not sure if isolating user groups will really solve the problem.
upvoted 0 times
...
Freeman
8 months ago
Wait, why are only the pilot users affected? That’s weird!
upvoted 0 times
...
Rose
8 months ago
Adding more nodes seems like overkill without checking the metrics first.
upvoted 0 times
...
Nada
8 months ago
Definitely agree, metrics can reveal a lot about performance issues.
upvoted 0 times
...
Tegan
8 months ago
I think checking the Cloud Monitoring metrics is a solid first step.
upvoted 0 times
...
Arlene
9 months ago
Adding more nodes seems like a quick fix, but I wonder if it would actually solve the problem or just mask it temporarily.
upvoted 0 times
...
Leonida
9 months ago
I feel like using Key Visualizer could give us insights into the data access patterns, but I can't recall if it directly addresses performance issues.
upvoted 0 times
...
Leonida
9 months ago
Checking the Cloud Monitoring metrics sounds familiar; I think it could help identify if there's a resource issue.
upvoted 0 times
...
Louvenia
9 months ago
I remember we discussed isolating user groups in a similar practice question, but I'm not sure if that's the best first step here.
upvoted 0 times
...
Sunshine
9 months ago
This seems straightforward to me. The new pilot users are the ones experiencing the performance issues, so I'd start by isolating them to a separate Bigtable instance. That should help narrow down the problem.
upvoted 0 times
...
Leila
9 months ago
I've seen issues like this before with Bigtable. My strategy would be to use the Key Visualizer tool to get a better understanding of the data distribution and potential hotspots. That should help point me in the right direction.
upvoted 0 times
...
Vilma
9 months ago
I'm a bit confused by this question. There are a few different options, but I'm not sure which one is the best approach. Maybe I'll try to eliminate the obvious wrong answers first.
upvoted 0 times
...
Tony
9 months ago
Okay, let's see. The key here is to isolate the issue and figure out what's causing the performance problems for the new pilot users. I think I'll start by checking the Cloud Monitoring metrics.
upvoted 0 times
...
Solange
9 months ago
Hmm, this seems like a tricky one. I'll need to think through the different options carefully to figure out the best approach.
upvoted 0 times
...
Callie
1 year ago
Hmm, I bet the new pilot users are all trying to access the same dataset at the same time. Key Visualizer to the rescue!
upvoted 0 times
Fatima
1 year ago
User 3: Once we pinpoint the issue, we can add more nodes to the Bigtable cluster if needed.
upvoted 0 times
...
Brande
1 year ago
User 2: Good idea. We can use Key Visualizer to identify any hotspots causing the poor performance.
upvoted 0 times
...
Hillary
1 year ago
User 1: Let's check the Cloud Monitoring table/bytes_used metric from Bigtable.
upvoted 0 times
...
...
Karol
1 year 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
Pedro
1 year ago
User 3: Adding more nodes to the Bigtable cluster could also help improve performance.
upvoted 0 times
...
Mirta
1 year ago
Lazaro: Let's try Key Visualizer first and see if that helps pinpoint the problem.
upvoted 0 times
...
Yun
1 year ago
User 3: Adding more nodes to the Bigtable cluster could also help with the poor performance issue.
upvoted 0 times
...
Johnna
1 year ago
User 2: 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
...
Lazaro
1 year ago
User 2: I think Key Visualizer might be more helpful in this situation. It can identify data skew or hotspots.
upvoted 0 times
...
Nohemi
1 year ago
User 1: Have you checked the Cloud Monitoring table/bytes_used metric from Bigtable?
upvoted 0 times
...
Brittney
1 year ago
User 1: Have you tried checking the Cloud Monitoring table/bytes_used metric from Bigtable?
upvoted 0 times
...
...
Delsie
1 year 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
Fausto
1 year ago
Let's start by checking the Cloud Monitoring table/bytes_used metric from Bigtable and using Key Visualizer.
upvoted 0 times
...
Valentin
1 year ago
I agree, isolating the user groups seems like a drastic solution.
upvoted 0 times
...
...
Yolando
1 year 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
1 year 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
...
Ashanti
1 year ago
Adding more nodes to the Bigtable cluster could also be a good solution to improve performance.
upvoted 0 times
...
Floyd
1 year ago
I agree with Aron. That could help us identify the root cause of the poor performance.
upvoted 0 times
...
Aron
1 year ago
I think we should check the Cloud Monitoring table/bytes_used metric from Bigtable.
upvoted 0 times
...

Save Cancel