nerdexam
GoogleGoogle

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #122

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

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

Optimizing Database Solutions

Question

Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?

Options

  • AExport the data from the existing instance, and import the data into a new instance with solid-
  • BEdit the instance to change the storage type from HDD to SSD.
  • CCreate a high availability (HA) failover instance with SSDs, and perform a failover to the new
  • DCreate a read replica of the instance with SSDs, and perform a failover to the new instance

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 SQL for MySQL#Performance Optimization#Storage Management#Database Migration
Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER PracticeBrowse All PROFESSIONAL-CLOUD-DATABASE-ENGINEER Questions