Question 24 of 139
Single answerYour organization deployed a new version of a critical application that uses Cloud SQL for MySQL with high
availability (HA) and binary logging enabled to store transactional information. The latest release of the application
had an error that caused massive data corruption in your Cloud SQL for MySQL database. You need to minimize
data loss. What should you do?
AOpen the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated
backup before the corruption.
.
BReload the Cloud SQL for MySQL database using the LOAD DATA command to load data from CSV files that
were used to initialize the instance.
✓CPerform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before
the data was corrupted.
DFail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that
occurred before the corruption
✓
Correct Answer: C
Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.