AWS Certified Solutions Architect – Associate (SAA-C03)Design Resilient ArchitecturesEasy
A large enterprise is migrating its on-premises data warehouse, which stores petabytes of historical sales and customer data, to AWS. The data warehouse needs to support complex analytical queries and generate business intelligence reports. It requires high performance for these analytical workloads and must be cost-effective for large-scale data storage. Which AWS service is best suited for this requirement?
- AAmazon Aurora
- BAmazon DynamoDB
- CAmazon RDS for PostgreSQL
- DAmazon Redshift
Show answer & explanationAnswer & explanation
Correct answer: D. Amazon Redshift
Amazon Redshift is a fully managed, petabyte-scale cloud data warehouse. It is designed for analytical workloads, supporting complex queries over large datasets and integrating with business intelligence tools, making it ideal for migrating an on-premises data warehouse.
Why the other options are wrong
- A. Amazon Aurora is a relational database compatible with MySQL and PostgreSQL, optimized for transactional workloads, not a data warehouse for large-scale analytics.
- B. Amazon DynamoDB is a NoSQL database, designed for high-performance key-value and document workloads, not for complex SQL analytical queries over petabytes of historical data.
- C. Amazon RDS for PostgreSQL is a relational database service, suitable for transactional workloads, not optimized for petabyte-scale analytical data warehousing.
Amazon Redshift
A fully managed, petabyte-scale cloud data warehouse service optimized for analytical workloads, supporting complex SQL queries and integrating with business intelligence tools.
- Columnar storage for fast analytical queries.
- Massively Parallel Processing (MPP) architecture.
- Cost-effective for large-scale data warehousing.
Memory trick: Redshift's the choice, for data's big voice, analytics thrive, making businesses alive.