ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam
Go to Exam

Exam Professional Cloud Database Engineer topic 1 question 72 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 72
Topic #: 1
[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?

  • 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.
  • C. Use Key Visualizer for Bigtable.
  • D. Add more nodes to the Bigtable cluster.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by pk349 at Dec. 24, 2022, 11:57 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
chelbsik
Highly Voted 1 year, 10 months ago
Selected Answer: C
First step of performance troubleshooting is to use Key Visualizer https://cloud.google.com/bigtable/docs/performance#troubleshooting
upvoted 8 times
...
dynamic_dba
Highly Voted 1 year, 7 months ago
C. The test data set is likely to have poor row key design. When loaded into the database, that data is probably hitting the same node and causing a hot spot. Addng more nodes will not solve a hot spot. Eliminate D. Neither will creating a new instance (A). B might be of interest, but is not the primary tool to diagnose Bigtable performance problems. For that, use Key Visualizer. Best answer is C. https://cloud.google.com/bigtable/docs/keyvis-overview
upvoted 7 times
...
dija123
Most Recent 5 months, 1 week ago
Selected Answer: C
Agree with Key Visualizer
upvoted 1 times
...
pk349
1 year, 10 months ago
B: Check the Cloud Monitoring table/bytes_used *** metric from Bigtable. Read throughput The number of bytes per second of response data sent. This metric refers to the full amount of data that is returned after filters are applied. Write throughput The number of bytes per second that were received when data was written.
upvoted 1 times
chelbsik
1 year, 10 months ago
Where did you get that from? table/bytes_used - Amount of compressed data stored in a table. Sampled every 60 seconds. After sampling, data is not visible for up to 120 seconds. https://cloud.google.com/bigtable/docs/metrics#:~:text=Bigtable%20application%20profile.-,table/bytes_used,-GA%0AData%20stored
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago