CloudGuild · Blog · Cheat sheets · Lessons · Certifications
AWS SAA-C03 Exam Question Walkthrough: Choosing the Right Data Solution
Tackle the AWS SAA-C03 exam with confidence. Understand how to choose the best data solution for cost and performance.
Migrating data to AWS presents unique challenges. Candidates often struggle with selecting the right service that balances cost and performance. This decision can significantly impact both the budget and the efficiency of analytics.
The question
A company is migrating its data warehouse to AWS and needs a solution that minimizes costs while providing the best performance for analytics. They expect to run complex queries on large datasets but want to avoid over-provisioning. Which service should they choose?
- A. Amazon Redshift
- B. Amazon RDS
- C. Amazon S3 with Athena
- D. Amazon DynamoDB
Think before you scroll
Consider the company's need for cost efficiency and performance. They require a solution that can handle complex queries without the overhead of provisioning resources.
The answer
The correct option is C. Amazon S3 with Athena. This service allows the company to run SQL queries directly on data stored in S3. It eliminates the need for provisioning a data warehouse, making it a cost-effective choice, especially for infrequently accessed data.
Why the other options lose
- A. Amazon Redshift: While it is a powerful data warehousing solution, it requires provisioning of resources. This can lead to higher costs, particularly if the company has fluctuating data access needs.
- B. Amazon RDS: This is a managed relational database service. It is great for transactional workloads but not optimized for complex analytical queries on large datasets. It also requires provisioning, thus increasing costs.
- D. Amazon DynamoDB: This NoSQL database is not designed for complex analytical queries. It is more suited for high-velocity transactional workloads, making it an inappropriate choice for this scenario.
The concept behind it
The key principle here is understanding the difference between data warehousing and analytics solutions. Using Amazon S3 with Athena allows businesses to query data without needing to provision any additional resources. This approach is especially beneficial for handling large datasets that are not accessed frequently.
Exam trap to remember
Always prioritize services that minimize costs while meeting performance requirements. The two-question rule applies here: if a scenario involves cost and performance, consider serverless solutions like Athena first.