Google Associate Cloud Engineer
Get started today
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?
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?
Explanation:
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.