DEA-C01 Question 180
Select 2You are tasked with migrating a large on-premises data warehouse to AWS. The data consists of structured and semi-structured formats, and there is a requirement for high availability and scalability. Additionally, the business needs the ability to query the data immediately after migration without building a new ETL pipeline. Which combination of AWS services and storage options should you use to align with these requirements?
- A
Use Amazon S3 as the primary storage layer and enable S3 Select for querying data directly.
- B
Migrate the data to Amazon Redshift and use Redshift Spectrum to query data stored in Amazon S3.
- C
Store the data in Amazon RDS and use Amazon Athena to query the data.
- D
Move the data to Amazon DynamoDB for highly scalable storage and querying capabilities.
- E
Store the data in Amazon S3 and use Amazon Athena for serverless querying of the data.
Show answer and explanation
Correct answers: B, E
Explanation
To align data storage with the requirements for scalability, high availability, and immediate query access, using Amazon Redshift with Redshift Spectrum or Amazon S3 with Amazon Athena is the most appropriate solution. Redshift Spectrum allows querying data directly in S3 without requiring an ETL process, while Athena provides a serverless query service for data stored in S3. Both options support structured and semi-structured data, making them well-suited for the scenario.
- A. Incorrect.
Using Amazon S3 with S3 Select provides a way to query specific portions of the data stored in S3, but it is not suitable for querying large-scale structured and semi-structured data together or immediately after migration.
- B. Correct.
Amazon Redshift with Redshift Spectrum is an optimal choice because Redshift Spectrum allows querying data directly from S3, combining the benefits of a data warehouse and data lake. This satisfies the immediate querying requirement.
- C. Incorrect.
Amazon RDS is a managed relational database service and is not designed for direct querying of large-scale data immediately after migration, nor does it integrate with Amazon Athena for querying.
- D. Incorrect.
Amazon DynamoDB is a NoSQL database service and is not suitable for querying structured and semi-structured data in the context of a data warehouse migration.
- E. Correct.
Storing data in Amazon S3 and using Amazon Athena is an excellent solution for serverless querying of structured and semi-structured data immediately after migration. This aligns well with the requirements.