SAP-C02 Question 158
Select 2A company is migrating its on-premises data analytics platform to AWS. The platform processes large volumes of data and requires scalable storage, high-throughput compute, and the ability to run complex SQL queries across structured and semi-structured datasets. The company also wants to minimize the operational overhead associated with managing infrastructure. Which combination of AWS services should the Solutions Architect recommend to meet these requirements?
- A
Amazon Redshift
- B
Amazon Athena
- C
Amazon EMR
- D
Amazon RDS
- E
Amazon DynamoDB
Show answer and explanation
Correct answers: A, B
Explanation
To meet the requirements of scalable storage, high-throughput compute, and the ability to run complex SQL queries on structured and semi-structured data while minimizing operational overhead, the combination of Amazon Redshift and Amazon Athena is ideal. Redshift provides high-performance analytics for large-scale datasets, while Athena complements it with serverless querying capabilities for data stored in S3. This combination provides both scalability and operational efficiency.
- A. Correct.
Amazon Redshift is a fully managed data warehouse that supports complex SQL queries and is designed for analytics at scale. It is an ideal solution for processing large datasets efficiently.
- B. Correct.
Amazon Athena is a serverless query service that allows you to run SQL queries on data stored in Amazon S3. It is highly scalable and eliminates the need to manage infrastructure.
- C. Incorrect.
Amazon EMR is useful for big data processing using frameworks like Apache Spark or Hadoop, but it requires more operational management compared to serverless options like Athena.
- D. Incorrect.
Amazon RDS is a managed relational database service optimized for transactional workloads rather than analytics. It is not ideal for large-scale analytics with complex queries.
- E. Incorrect.
Amazon DynamoDB is a fully managed NoSQL database service designed for key-value and document-based workloads. It is not suitable for running SQL-based analytics on structured or semi-structured data.