SAA-C03 Q86 · Migration

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?

Accepted Answer

Option D meets every requirement with minimal operational overhead:

1. **Archive the database**: AWS DMS can migrate data from an on-premises relational database directly to Amazon S3 as a target. DMS supports outputting data in **Apache Parquet format**, which is a columnar storage format ideal for analytics.

2. **Retain the data cost-effectively**: Storing data in **S3 Glacier Flexible Retrieval** provides extremely low-cost archival storage. Since reports are only needed annually, this tier is appropriate — data can be restored within hours when needed.

3. **Run SQL queries on archived data**: **Amazon Athena** is a serverless query service that can run standard SQL queries directly against data stored in S3. Athena natively understands Parquet format and works efficiently with it du

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips