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?

The correct answer is A. Set up an export job for the first of the month.. https://cloud.google.com/sql/docs/mysql/backup-recovery/backups Not B: Automatic backups are made EVERY SINGLE DAY. You can set only the number of backups up to 365. Also you cannot choose your Archival storage as destination Not C: You cannot setup "on-demand" backup. User would

Submitted by weili_xi· Mar 30, 2026Ensuring successful operation of a cloud solution

Question

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?

Options

ASet up an export job for the first of the month.
BSave the automatic first-of-the-month backup for three years.
CSet up an on-demand backup for the first of the month.
DConvert the automatic first-of-the-month backup to an export file.

How the community answered

(51 responses)

A
94% (48)
B
4% (2)
C
2% (1)

Explanation

https://cloud.google.com/sql/docs/mysql/backup-recovery/backups Not B: Automatic backups are made EVERY SINGLE DAY. You can set only the number of backups up to 365. Also you cannot choose your Archival storage as destination Not C: You cannot setup "on-demand" backup. User would have to make backups manually every month. Also you cannot choose your Archival storage as destination Not D: You cannot convert backup to export file. Also Coldline class is less cost-effective than

Topics

#Cloud SQL#data export#backup strategy#audit compliance

Community Discussion

No community discussion yet for this question.

Full ASSOCIATE-CLOUD-ENGINEER Practice