SAA-C03 Question 358
Single answerA retail company collects transactional data from its point-of-sale systems and stores it in Amazon S3 in JSON format. The company wants to transform this data into a structured format (Parquet) to optimize query performance in Amazon Athena. They also want the solution to be serverless and capable of handling schema discovery automatically. Which AWS service is best suited for this use case?
- A
AWS Glue
- B
Amazon EMR
- C
AWS Lambda
- D
Amazon Redshift
Show answer and explanation
Correct answer: A
Explanation
AWS Glue is the best choice for this scenario because it is a serverless ETL (Extract, Transform, Load) service capable of discovering schemas automatically and transforming data into optimized formats like Parquet. This makes it highly suitable for use cases like preparing data for querying in Amazon Athena. Other options either lack the required capabilities or are not serverless.
- A. Correct.
AWS Glue is a serverless data integration service that can automatically discover schemas, transform data, and save it in optimized formats like Parquet, making it the ideal choice for this use case.
- B. Incorrect.
Amazon EMR is a scalable big data processing service, but it is not serverless and requires more configuration and management compared to AWS Glue.
- C. Incorrect.
AWS Lambda can process data, but it is not specifically designed for large-scale ETL tasks like schema discovery and data format conversion.
- D. Incorrect.
Amazon Redshift is a data warehouse service and is not designed for transforming data stored in Amazon S3 into different formats.