AWS Certified Solutions Architect – ProfessionalAccelerate Workload Migration and ModernizationMedium
A large insurance company is migrating its data warehouse from an on-premises Teradata system to AWS. The current system is petabyte-scale, requires complex SQL queries for business intelligence, and needs to scale compute and storage independently. The company wants to minimize the operational burden of managing the data warehouse infrastructure while ensuring high performance for analytical workloads. Which AWS service is the MOST appropriate for this migration?
- AAmazon Aurora Serverless v2
- BAmazon Athena
- CAmazon RDS for PostgreSQL
- DAmazon Redshift
Show answer & explanationAnswer & explanation
Correct answer: D. Amazon Redshift
Amazon Redshift is a fully managed, petabyte-scale data warehouse service designed for analytical workloads and complex SQL queries. It allows for independent scaling of compute and storage (using RA3 instances with managed storage) and significantly reduces the operational burden compared to managing an on-premises Teradata system.
Why the other options are wrong
- A. Aurora Serverless v2 is a relational database for OLTP, not a data warehouse. While it scales compute and storage, it's not designed for the specific analytical performance and scale of a Teradata replacement.
- B. Athena is a serverless query service for S3 data, suitable for ad-hoc queries but not a fully managed data warehouse with dedicated compute and optimized for existing complex SQL like Redshift.
- C. RDS for PostgreSQL is a relational database for OLTP workloads, not optimized for petabyte-scale analytical data warehousing or independent scaling of compute and storage.
Amazon Redshift
A fully managed, petabyte-scale data warehouse service in the cloud that allows you to run complex analytic queries against structured data.
- Optimized for analytical workloads and SQL queries.
- Scales compute and storage independently with RA3 instances.
- Offers high performance for large datasets.
Memory trick: Redshift is your 'Red carpet' to a scalable, managed data warehouse.