Google Cloud Professional Cloud Database Engineer — Question 4

Your customer has a global chat application that uses a multi-regional Cloud Spanner instance. The application has recently experienced degraded performance after a new version of the application was launched. Your customer asked you for assistance. During initial troubleshooting, you observed high read latency. What should you do?

Answer options

• A. Use query parameters to speed up frequently executed queries.
• B. Change the Cloud Spanner configuration from multi-region to single region.
• C. Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.
• D. Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.

Correct answer: C

Explanation

The correct answer is C because analyzing the SPANNER_SYS.READ_STATS* tables provides insights into read latency patterns, which can help identify performance bottlenecks. Options A and B do not directly address the issue of high read latency, while D focuses on query statistics rather than specifically on read performance.