AWS Certified Cloud Practitioner — Question 343

A company wants to migrate its on-premises data warehouse to AWS. The information in the data warehouse is used to populate analytics dashboards.

Which AWS service should the company use for the data warehouse?

Answer options

• A. Amazon ElastiCache
• B. Amazon Aurora
• C. Amazon RDS
• D. Amazon Redshift

Correct answer: D

Explanation

Amazon Redshift is a fully managed, petabyte-scale data warehouse service optimized for analytical workloads, making it the ideal destination for migrating an on-premises data warehouse. Amazon RDS and Amazon Aurora are designed for online transaction processing (OLTP) rather than complex analytical queries (OLAP). Amazon ElastiCache is an in-memory caching service used to improve database performance, not a data warehousing solution.