Google Cloud Professional Cloud Database Engineer — Question 103

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?

Answer options

• A. Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).
• B. Edit the instance to change the storage type from HDD to SSD.
• C. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
• D. Create a read replica of the instance with SSDs, and perform a failover to the new instance

Correct answer: A

Explanation

The correct answer is A because exporting the data to a new instance with SSDs will directly improve disk performance. Option B is incorrect as simply changing the storage type may not be feasible if the instance is already under heavy load. Option C, while it creates an HA instance, does not directly address the performance issue of the original instance. Option D does not resolve the performance of the primary database and only provides a read replica, which may still suffer from the same I/O issues.