SAP-C02 Question 329
Single answerA company is migrating its on-premises data warehouse to AWS. Their primary goal is to leverage a scalable, serverless architecture for processing and querying structured data while maintaining compatibility with standard SQL. They also require the ability to query data stored in Amazon S3 without needing to move it to a traditional database. Which AWS service meets these requirements?
- A
Amazon Redshift
- B
Amazon Athena
- C
Amazon RDS for PostgreSQL
- D
AWS Glue
Show answer and explanation
Correct answer: B
Explanation
The company requires a serverless service that can query structured data stored in Amazon S3 using standard SQL. Amazon Athena is the best choice because it is serverless, supports SQL, and allows querying data directly in Amazon S3 without the need for data movement. Other services like Amazon Redshift or RDS require data to be loaded into their respective systems, which does not meet the requirements. AWS Glue focuses on ETL processes rather than direct querying.
- A. Incorrect.
Amazon Redshift is a managed data warehouse service, but it is not serverless by default. It is designed for high-performance analytics but requires the data to be loaded into the Redshift cluster, which does not meet the requirement to query data directly in Amazon S3.
- B. Correct.
Amazon Athena is a serverless query service that allows you to use standard SQL to query data stored in Amazon S3 without moving it to another storage service. This aligns perfectly with the company's requirements.
- C. Incorrect.
Amazon RDS for PostgreSQL is a managed relational database service. While it supports SQL, it is not serverless and does not natively support querying data stored directly in Amazon S3.
- D. Incorrect.
AWS Glue is primarily an ETL (Extract, Transform, Load) service that prepares and transforms data for analysis. While it integrates with Amazon S3, it is not designed to directly query data using SQL.