Google Professional Cloud Database Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
How can you minimize data loss in a Cloud SQL for MySQL database with high availability (HA) and binary logging enabled after a critical application update caused significant data corruption?
A
Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.
B
Reload the Cloud SQL for MySQL database using the LOAD DATA command to load data from CSV files that were used to initialize the instance.
C
Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.
D
Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.