SAP-C02 Question 298
Single answerA company is migrating its on-premises data warehouse to AWS and needs to select an appropriate storage service to analyze large-scale datasets with SQL queries. The solution should minimize management overhead and scale automatically to meet demand. Which service best meets these requirements?
- A
Amazon Redshift
- B
Amazon RDS for PostgreSQL
- C
Amazon S3 with Athena
- D
Amazon DynamoDB
Show answer and explanation
Correct answer: C
Explanation
Amazon S3 with Athena is the best choice because it allows the company to run SQL queries directly on data stored in S3 without requiring any management of infrastructure. Athena scales automatically to meet demand, making it ideal for large-scale data analytics workloads with minimal management overhead.
- A. Incorrect.
Amazon Redshift is a managed data warehouse solution, but it requires setting up and managing clusters, which contradicts the requirement to minimize management overhead. It also does not analyze data directly on S3 without ingestion into Redshift.
- B. Incorrect.
Amazon RDS for PostgreSQL is a managed relational database service, but it is not designed for large-scale data analytics and does not scale automatically to handle big data workloads.
- C. Correct.
Amazon S3 with Athena allows you to analyze large datasets stored in Amazon S3 using SQL queries without the need to manage any infrastructure. It scales automatically and is highly suitable for large-scale data analytics workloads.
- D. Incorrect.
Amazon DynamoDB is a NoSQL database optimized for key-value and document-based use cases. It is not designed for running SQL queries or analyzing large-scale datasets.