SAP-C02 Question 354
Select 2A company is building a scalable web application that requires a managed database solution for handling transactional workloads with minimal operational overhead. The team also needs a managed service to perform scheduled data analytics on the database without impacting the performance of the live application. Which combination of AWS managed services meets these requirements?
- A
Amazon RDS for the database and AWS Glue for scheduled data analytics
- B
Amazon DynamoDB for the database and AWS Glue for scheduled data analytics
- C
Amazon Aurora for the database and Amazon Redshift for scheduled data analytics
- D
Amazon RDS for the database and Amazon EMR for scheduled data analytics
- E
Amazon DynamoDB for the database and Amazon Redshift for scheduled data analytics
Show answer and explanation
Correct answers: A, C
Explanation
AWS offers multiple managed services for specific use cases. For transactional workloads, Amazon RDS and DynamoDB are excellent choices depending on whether you require a relational or NoSQL database. For scheduled data analytics, AWS Glue is a serverless option that supports integration with both RDS and DynamoDB. These combinations (RDS + Glue or DynamoDB + Glue) minimize operational overhead and meet the requirements effectively.
- A. Correct.
Amazon RDS is a fully managed relational database service suitable for transactional workloads. AWS Glue is a serverless data integration service that can perform scheduled data analytics, making this a valid solution.
- B. Incorrect.
Amazon DynamoDB is a fully managed NoSQL database suitable for high-throughput, low-latency transactional workloads. AWS Glue can integrate with DynamoDB to perform scheduled data analytics, making this a valid solution.
- C. Correct.
Amazon Aurora is a managed relational database service optimized for transactional workloads. Amazon Redshift is a data warehouse service optimized for analytics, but it requires data to be loaded from Aurora, which adds complexity. This is not the most suitable combination for seamless analytics.
- D. Incorrect.
Amazon RDS is a managed relational database service, but Amazon EMR is best suited for large-scale big data processing, not scheduled data analytics on transactional data. This is not the ideal solution.
- E. Incorrect.
Amazon DynamoDB is suitable for transactional workloads, but Amazon Redshift is not designed for direct integration with DynamoDB for analytics without additional steps like data export. This combination does not fully meet the requirements.