nerdexam
GoogleGoogle

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #108

PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #108: Real Exam Question with Answer & Explanation

Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #108. The question stem and answer options stay visible for context.

Troubleshooting a database solution

Question

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?

Options

  • AUse query parameters to speed up frequently executed queries.
  • BChange the Cloud Spanner configuration from multi-region to single region.
  • CUse SQL statements to analyze SPANNER_SYS.READ_STATS* tables.
  • DUse SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.

Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer

You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Cloud Spanner Performance#Database Monitoring#Troubleshooting Read Latency#Spanner System Tables
Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER PracticeBrowse All PROFESSIONAL-CLOUD-DATABASE-ENGINEER Questions