SAP-C02 Question 124
Single answerA company needs to migrate its on-premises data warehouse to AWS. The data warehouse must handle petabytes of data, support complex queries, and provide near real-time insights. The company also requires the solution to be cost-effective and elastic, with the ability to scale up or down based on workload. Which AWS service should you choose to meet these requirements?
- A
Amazon Redshift
- B
Amazon RDS with PostgreSQL
- C
Amazon EMR with Hadoop and Presto
- D
Amazon DynamoDB
Show answer and explanation
Correct answer: A
Explanation
Amazon Redshift is the best choice for building a data warehouse in AWS. It is specifically designed for handling petabyte-scale data, supporting complex analytical queries, and providing near real-time insights, all while being cost-effective and scalable. Other options, such as RDS, EMR, or DynamoDB, do not meet the specific requirements of a data warehouse with these capabilities.
- A. Correct.
Amazon Redshift is a fully managed data warehouse service designed to handle petabyte-scale data, support complex analytical queries, and provide near real-time insights. It offers cost-effective pricing and elastic scaling options.
- B. Incorrect.
Amazon RDS with PostgreSQL is a managed relational database service that is not optimized for large-scale data warehousing or complex analytical workloads.
- C. Incorrect.
Amazon EMR with Hadoop and Presto is suitable for big data processing and ad-hoc querying but is not a data warehouse solution. It requires more management and is less cost-effective for the use case described.
- D. Incorrect.
Amazon DynamoDB is a NoSQL database designed for high-performance key-value and document use cases, but it is not suitable for data warehousing or complex query requirements.