Question #782
Which AWS service can run a managed Microsoft SQL Server database that provides online transaction processing (OLTP)?
Amazon DynamoDB
Amazon Athena
Amazon RDS
Amazon EMR
Explanation
Amazon RDS is AWS's managed relational database service that supports multiple database engines, including Microsoft SQL Server. It is specifically designed for OLTP workloads, which involve frequent, short transactions like inserts, updates, and deletes.
- Why C is correct: RDS handles database management tasks (e.g., patching, backups) while allowing users to run a fully managed SQL Server instance optimized for transactional processing.
- Why others are incorrect:
- A (DynamoDB): A NoSQL database, not compatible with SQL Server.
- B (Athena): A serverless query service for S3 data, not a transactional database.
- D (EMR): A big data processing service (e.g., Hadoop/Spark), not a relational database.
Key Points: RDS supports SQL Server; OLTP requires a relational database; managed services offload administrative tasks.
Answer
The correct answer is: C