Answer-first summary for fast verification
Answer: Amazon Redshift
Amazon Redshift is a fully managed, petabyte-scale data warehouse service that is optimized for large-scale data set storage and complex queries. It can handle the expected growth of the dataset and provides real-time analytics capabilities. Amazon RDS with PostgreSQL is a relational database service, but it is not designed for large-scale data warehousing. Amazon DynamoDB is a NoSQL database service that is suitable for applications that require single-digit millisecond latency at any scale, but it is not optimized for complex queries. Amazon EMR is a big data platform for processing vast amounts of data using popular frameworks such as Apache Spark, Hadoop, and Presto. However, it is not a data warehouse service.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your company is planning to migrate a large dataset from an on-premises data warehouse to AWS. The dataset is expected to grow by 20% annually, and the company requires real-time analytics capabilities. Which AWS service should you choose and why?
A
Amazon RDS with PostgreSQL
B
Amazon Redshift
C
Amazon DynamoDB
D
Amazon EMR
No comments yet.