A company is migrating an SAP BusinessObjects system to AWS. The system includes a Central Management Server (CMS) and several processing servers. The CMS uses a SQL Server database. The company wants to use a managed database service on AWS to reduce operational overhead. The database size is 100 GB and is expected to grow 10% annually. The company requires automatic failover to a secondary Availability Zone with minimal downtime. Which AWS database service should the company use for the CMS database?
RDS for SQL Server with Multi-AZ provides automatic failover and reduces operational overhead.
Why this answer
Option C is correct because Amazon RDS for SQL Server with Multi-AZ provides automatic failover to a standby in another AZ. Option A is wrong because Amazon Aurora is not compatible with SQL Server. Option B is wrong because SQL Server on EC2 is not managed.
Option D is wrong because Amazon DynamoDB is NoSQL and not compatible with SQL Server.