Answer-first summary for fast verification
Answer: Edit the instance to change the storage type from HDD to SSD.
To improve performance and reduce disk I/O wait times for a Cloud SQL for MySQL backend database that is currently using hard disk drives (HDDs), the most straightforward and efficient solution is to change the storage type from HDD to SSD. This can be done by editing the instance settings. Option A suggests exporting and importing data into a new instance with SSDs, which is a valid approach but more time-consuming and complex than simply changing the storage type of the existing instance. Option C suggests creating a high availability (HA) failover instance with SSDs and performing a failover, which is unnecessary for improving disk performance unless HA is also a requirement. Option D suggests creating a read replica with SSDs and performing a failover, which is also more complex than needed for the stated problem. Therefore, the best answer is to edit the instance to change the storage type from HDD to SSD.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you enhance performance and minimize disk I/O wait times for a Cloud SQL for MySQL database using HDDs, which is experiencing slow disk performance due to a viral surge in your organization's app?
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
No comments yet.