AWS Certified Cloud Practitioner
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
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?
Real Exam
Community
RRitesh
A
Amazon Redshift
B
Amazon DynamoDB
C
Amazon S3
D
Amazon Aurora
Explanation:
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.
Comments
Loading comments...