SAA-C03 · Question #457
SAA-C03 Question #457: Real Exam Question with Answer & Explanation
The correct answer is D: Use AWS Database Migration Service (AWS DMS) to migrate the on-premises databases to. Amazon S3 is the most cost-effective option for archiving data. Using AWS DMS to migrate to S3 in Apache Parquet format provides an optimized columnar format for analytics. By storing in S3 Glacier Flexible Retrieval, costs are minimized while maintaining compliance with retentio
Question
A company needs to archive an on-premises relational database. The company wants to retain the data. The company needs to be able to run SQL queries on the archived data to create annual reports. Which solution will meet these requirements with the LEAST operational overhead?
Options
- AUse AWS Database Migration Service (AWS DMS) to migrate the on-premises database to an
- BSet up database replication from the on-premises database to an Amazon EC2 instance. Retire
- CCreate a database backup on premises. Use AWS DataSync to transfer the data to Amazon S3.
- DUse AWS Database Migration Service (AWS DMS) to migrate the on-premises databases to
Explanation
Amazon S3 is the most cost-effective option for archiving data. Using AWS DMS to migrate to S3 in Apache Parquet format provides an optimized columnar format for analytics. By storing in S3 Glacier Flexible Retrieval, costs are minimized while maintaining compliance with retention. When queries are required, Athena can run SQL queries directly on archived data in S3 without provisioning infrastructure. Options A and B rely on maintaining RDS or EC2 instances, which increases cost and operational overhead. Option C requires full restores to EC2 before running queries, which is slow and inefficient. Therefore, D provides the lowest operational overhead and direct query capability with Athena.
Community Discussion
No community discussion yet for this question.