Google Cloud Professional Cloud Database Engineer — Question 60

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?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because using the Recommender API helps identify instances that are overprovisioned, allowing you to reduce costs by resizing them appropriately. Option A is incorrect as identifying idle instances does not directly lead to cost savings. Option B is not related to instance optimization, and option D, while helpful for performance, does not specifically address cost optimization.