
Answer-first summary for fast verification
Answer: Amazon Redshift
## Explanation **Amazon Redshift** is the correct choice because: - **Data Warehouse Purpose**: Amazon Redshift is specifically designed as a cloud data warehouse service optimized for large-scale data analytics - **Terabyte-Scale Storage**: It can handle petabytes of data, easily supporting terabytes as mentioned in the requirement - **Complex Analytic Queries**: Redshift uses columnar storage and massively parallel processing (MPP) architecture, making it ideal for complex analytical queries and business intelligence workloads - **Performance**: Optimized for read-heavy analytical workloads with advanced query optimization and compression **Why other options are incorrect**: - **Amazon DynamoDB**: NoSQL database service, not designed for complex analytic queries or data warehousing - **Amazon S3**: Object storage service, not a database or data warehouse - can store data but doesn't process queries - **Amazon Aurora**: Relational database optimized for OLTP (Online Transaction Processing), not OLAP (Online Analytical Processing) workloads Amazon Redshift is AWS's fully managed, petabyte-scale data warehouse service specifically built for large-scale data analytics and complex query processing.
Author: Ritesh Yadav
Ultimate access to all questions.
A company is moving its data warehouse to AWS. The infrastructure on AWS must support the storage of terabytes of data and must process complex analytic queries. Which AWS service will meet these requirements?
A
Amazon Redshift
B
Amazon DynamoDB
C
Amazon S3
D
Amazon Aurora
No comments yet.