Google Cloud Associate Cloud Engineer — Question 155

You are working with a Cloud SQL MySQL database at your company. You need to retain a month-end copy of the database for three years for audit purposes.
What should you do?

Answer options

• 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.

Correct answer: A

Explanation

The correct answer is A because setting up an export job specifically for the first of the month allows you to retain a copy of the database as needed for audit purposes and storing it in an Archive class Cloud Storage bucket is ideal for long-term storage. Options B and C do not provide the required export format, and option D suggests using a Coldline class bucket, which is not optimal for frequent access like monthly audits.