Answer-first summary for fast verification
Answer: Set up an export job for the first of the month. Write the export file to an Archive class Cloud Storage bucket.
The correct answer is A. Automatic backups cannot be exported, and there is no way to keep them for three years directly within Cloud SQL. By setting up an export job for the first of the month and writing the export file to an Archive class Cloud Storage bucket, you ensure that you have a copy stored in long-term, cost-effective storage for compliance purposes. Options B, C, and D are not valid because automatic backups cannot be exported, and Cloud SQL does not support on-demand backups being scheduled automatically or stored directly in Archive class storage.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are managing a Cloud SQL MySQL database for your company and have been tasked with ensuring compliance with audit requirements. Specifically, you are required to retain a copy of the database at the end of each month for a duration of three years. What steps should you take to achieve this objective?
A
Set up an export job for the first of the month. Write the export file to an Archive class Cloud Storage bucket.
B
Save the automatic first-of-the-month backup for three years. Store the backup file in an Archive class Cloud Storage bucket.
C
Set up an on-demand backup for the first of the month. Write the backup to an Archive class Cloud Storage bucket.
D
Convert the automatic first-of-the-month backup to an export file. Write the export file to a Coldline class Cloud Storage bucket.
No comments yet.