CloudGuild · Blog · Cheat sheets · Lessons · Certifications
AWS Certified Solutions Architect - Associate: Analyzing Data in Amazon S3
Explore a question on analyzing data in Amazon S3 for the SAA-C03 exam. Understand the right choice and why others fail.
Deciding on the best AWS service for analyzing data can trip up many candidates. The options may seem similar, but only one service stands out for this specific scenario.
The question
A business wants to analyze large amounts of data stored in Amazon S3 without incurring high costs. They are considering using a service that allows them to run SQL queries directly on their S3 data. Which AWS service should they choose?
- A. Amazon RDS
- B. Amazon Athena
- C. Amazon Redshift
- D. AWS Glue
Think before you scroll
Consider the requirements: analyzing data in S3 without high costs. Each service has its strengths and weaknesses, and understanding these will guide your choice.
The answer
The correct option is B. Amazon Athena. This service allows users to run SQL queries directly on data stored in Amazon S3. It eliminates the need for complex data loading processes, making it a cost-effective solution for analytics.
Why the other options lose
- A. Amazon RDS: This option requires data to be stored in a relational database. RDS incurs higher costs because it involves provisioning and managing a database instance, which is not necessary for direct analysis of S3 data.
- C. Amazon Redshift: Similar to RDS, Redshift is a data warehouse solution that requires data to be loaded into its cluster. This not only adds complexity but also increases costs, making it unsuitable for the requirement of low-cost analysis directly on S3 data.
- D. AWS Glue: AWS Glue is primarily designed for ETL (Extract, Transform, Load) processes. While it can prepare data for analysis, it does not allow users to run SQL queries directly on S3 data, thus failing to meet the primary goal of this question.
The concept behind it
When analyzing data stored in Amazon S3, using a service like Amazon Athena is often the best choice. It provides a direct SQL interface for querying data without the need for data transformation or movement. Understanding the service capabilities helps when faced with similar scenarios in the exam.
Exam trap to remember
Remember: If you need to analyze data in S3 without moving it, think Athena. It’s your go-to for cost-effective SQL queries on S3 data.