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

Question

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

• A
  83% (40)
• B
  6% (3)
• C
  8% (4)
• D
  2% (1)

Explanation

Cloud SQL does not support in-place changes of storage type from HDD to SSD on an existing instance. The supported migration path is to export the data (e.g., to Cloud Storage), create a new Cloud SQL instance configured with SSD storage, and import the data into the new instance. Option B is incorrect because Cloud SQL does not allow you to edit an existing instance to switch its storage type after creation. Option C (HA failover to SSD) is invalid because HA standbys mirror the primary's storage type and cannot be independently set to SSD. Option D (read replica failover) is also invalid because read replicas in Cloud SQL do not support promotion-based failover in the same way HA does, and they would also inherit the HDD storage type.

No community discussion yet for this question.