DEA-C01 Question 178
Select 2A company wants to migrate their on-premises data warehouse to AWS. Their data consists of structured tables with petabytes of information, and it is queried frequently for business intelligence reports. They also want to ensure the migration process is cost-effective and supports incremental data updates during the transition. Which combination of storage services and strategies best aligns with their requirements?
- A
Use Amazon S3 as the primary storage layer with Parquet format for the data and Athena for querying during migration.
- B
Migrate the on-premises data warehouse directly to Amazon Redshift and use Redshift Spectrum for querying any remaining data in S3.
- C
Store the data in Amazon RDS using a relational schema and use database replication to keep it in sync during migration.
- D
Leverage AWS Snowball for initial bulk data transfer to Amazon S3, then use AWS DataSync for ongoing incremental updates.
- E
Store the data in DynamoDB for fast access and use DynamoDB Streams for incremental updates.
Show answer and explanation
Correct answers: B, D
Explanation
For structured data warehouse migrations, Amazon Redshift is the preferred service due to its high-performance analytics capabilities and support for incremental updates via Redshift Spectrum. AWS Snowball and AWS DataSync are well-suited for migrating large volumes of data and ensuring ongoing synchronization during the transition. These services together address the requirements for cost-effectiveness, incremental updates, and frequent querying during migration.
- A. Incorrect.
Amazon S3 with Parquet format and Athena can be cost-effective for querying unstructured or semi-structured data, but it is not ideal for a structured, high-frequency query use case like a data warehouse migration.
- B. Correct.
Amazon Redshift is designed for structured data warehousing and analytics. Redshift Spectrum allows querying data in S3, which aligns well with the company's requirements for incremental updates during migration.
- C. Incorrect.
Amazon RDS is suitable for transactional databases but not optimized for large-scale analytics or data warehouse workloads.
- D. Correct.
AWS Snowball is a cost-effective solution for bulk data transfer, and AWS DataSync supports incremental updates, making this a viable strategy for the migration process.
- E. Incorrect.
DynamoDB is a NoSQL database designed for low-latency access to key-value and document data, which does not align with the structured data warehousing use case.