SAP-C02 Question 13
Select 2A financial services company wants to modernize its on-premises data analytics platform by migrating to AWS. The solution needs to handle large-scale data processing, support querying of structured and semi-structured data, and integrate easily with business intelligence tools. Cost-efficiency is also a key consideration. Which combination of services would meet these requirements?
- A
Amazon Redshift and Amazon QuickSight
- B
Amazon EMR and Amazon Athena
- C
Amazon RDS and AWS Glue
- D
Amazon S3 and Amazon Athena
- E
Amazon DynamoDB and Amazon Redshift
Show answer and explanation
Correct answers: A, D
Explanation
The financial services company requires a solution that can process large-scale data, support querying structured and semi-structured data, and integrate with business intelligence tools while being cost-efficient. Amazon Redshift and Amazon QuickSight meet the analytics and visualization requirements, while Amazon S3 and Amazon Athena provide a cost-efficient data lake and querying solution. Both combinations align well with the company's needs and constraints.
- A. Correct.
Amazon Redshift is a fully managed data warehouse that supports querying large-scale structured and semi-structured data, and it integrates seamlessly with Amazon QuickSight for business intelligence visualization. This combination is cost-efficient and meets the requirements.
- B. Incorrect.
Amazon EMR is ideal for large-scale data processing, and Amazon Athena allows querying data directly from Amazon S3. This combination is highly scalable and cost-efficient, making it a suitable choice for handling the company's requirements.
- C. Incorrect.
Amazon RDS is a managed relational database service, but it is not designed for large-scale analytics or querying semi-structured data. AWS Glue is a data integration service, but it alone cannot handle the analytics requirements.
- D. Correct.
Amazon S3 serves as a cost-efficient data lake for storing large-scale data, and Amazon Athena allows querying data directly from S3. This combination supports structured and semi-structured data processing and is cost-efficient.
- E. Incorrect.
Amazon DynamoDB is a NoSQL database designed for low-latency key-value and document-based applications, which is not suitable for large-scale data analytics. Redshift could handle analytics, but this pairing does not meet the requirements for querying semi-structured data or cost-efficiency.