exam questions

Exam Professional Cloud Database Engineer All Questions

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

Exam Professional Cloud Database Engineer topic 1 question 106 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 106
Topic #: 1
[All Professional Cloud Database Engineer Questions]

Your organization has hundreds of Cloud SQL for MySQL instances. You want to follow Google-recommended practices to optimize platform costs. What should you do?

  • A. Use Query Insights to identify idle instances.
  • B. Remove inactive user accounts.
  • C. Run the Recommender API to identify overprovisioned instances.
  • D. Build indexes on heavily accessed tables.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
Pime13
5 months, 3 weeks ago
Selected Answer: C
https://cloud.google.com/sql/docs/mysql/recommender-sql-overprovisioned
upvoted 1 times
...
dynamic_dba
1 year, 7 months ago
C. This is a cost question, so eliminate anything that doesn’t address cost. Eliminate A, B and C. The right answer is to use Recommender. https://cloud.google.com/recommender/docs/overview
upvoted 3 times
...
Atnafu
1 year, 10 months ago
C The Cloud SQL overprovisioned instance recommender helps you detect instances that are unnecessarily large for a given workload. It then provides recommendations on how to resize such instances and reduce cost. This page describes how this recommender works and how to use it. https://cloud.google.com/sql/docs/mysql/recommender-sql-overprovisioned#:~:text=The%20Cloud%20SQL%20overprovisioned%20instance%20recommender%20helps%20you%20detect%20instances%20that%20are%20unnecessarily%20large%20for%20a%20given%20workload.%20It%20then%20provides%20recommendations%20on%20how%20to%20resize%20such%20instances%20and%20reduce%20cost.%20This%20page%20describes%20how%20this%20recommender%20works%20and%20how%20to%20use%20it.
upvoted 4 times
...
chelbsik
1 year, 10 months ago
Selected Answer: C
https://cloud.google.com/sql/docs/mysql/recommender-sql-overprovisioned
upvoted 4 times
...
pk349
1 year, 10 months ago
C: Run the Recommender *** API to identify overprovisioned instances. The Cloud SQL idle instance recommender helps you detect instances that might be idle and provides you insights and recommendations to help you reduce costs . The Cloud SQL overprovisioned instance recommender helps you detect instances that are unnecessarily large for a given workload.
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago