AWS Certified Data Engineer - Associate DEA-C01Demo

Question

A company uses a 1 ТВ Amazon Aurora MySQL database as an online transaction processing (OLTP) data store. The company must back up the database in the primary AWS Region and copy the backup to a secondary Region each month. After 180 days, the backups must transition to cold storage.

Which solution will satisfy these requirements with the LEAST impact on database performance?

A Create a backup plan in AWS Backup to schedule monthly snapshots and copy the snapshots to the secondary Region. Configure AWS Backup lifecycle settings to transition snapshots to cold storage after 180 days.
B Enable Amazon Aurora automated backups to create monthly snapshots. Configure a cross-Region copy of the snapshots to the secondary Region. Add an Amazon S3 Lifecycle policy to transition backups to Amazon S3 Glacier after 180 days.
C Create a backup plan in AWS Backup to schedule monthly snapshots and copy the snapshots to the secondary Region. Configure Amazon EventBridge to run the StartExportTask action to export snapshots to Amazon S3. Use an S3 Lifecycle policy to transition backups to Amazon S3 Glacier after 180 days.
D Create a backup plan in AWS Backup for monthly snapshots and secondary Region copies. Configure Amazon EventBridge to launch an Amazon EC2 instance that uses the mysqldump tool to export the database to Amazon S3. Use S3 Lifecycle policies to transition backups to Amazon S3 Glacier after 180 days.

Explanation

AWS Backup can create scheduled Aurora snapshots and copy them to another Region. Aurora is not supported for AWS Backup lifecycle transitions to cold storage, but exporting an Aurora snapshot to Amazon S3 permits an S3 Lifecycle rule to transition the exported data to S3 Glacier after 180 days. Snapshot export runs in the background and does not affect the performance of the active Aurora DB cluster.

Learn more

AWS Certified Data Engineer - Associate DEA-C01Demo

AstroTutor

Notes

Readiness

QuestionQ363

Community Discussion