Google Cloud Professional Cloud Database Engineer — Question 149

Your company is rapidly expanding its user base across North America, nearly doubling in the last 6 months. This expansion causes a substantial increase in query volume on your mission-critical Cloud SQL database. This has led to noticeable performance issues and slower query response times. You suspect that your Cloud SQL instance may not be able to handle the incremental load. You need to identify the root cause of this performance bottleneck and ensure that your database can scale with your growing user base. What should you do?

Answer options

• A. Migrate the database to Spanner.
• B. Evaluate the application connection pooling configuration settings.
• C. Review Cloud SQL System Insights for the instance, and analyze CPU, memory, and storage utilization metrics.
• D. Create two Cloud SQL instances, and split the workload between them.

Correct answer: C

Explanation

The correct answer is C because reviewing Cloud SQL System Insights allows you to analyze key performance metrics like CPU, memory, and storage utilization, which can help identify the root cause of the performance bottleneck. Option A, migrating to Spanner, may not address the immediate issue and would require significant changes. Option B focuses on application settings rather than the database performance itself, and option D, while it may help distribute load, does not directly address the performance issues without first identifying their cause.