PAS-C01 Design of SAP Workloads on AWS Practice Question
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?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Amazon RDS for SQL Server with Multi-AZ deployment
Amazon RDS for SQL Server with Multi-AZ deployment is the correct choice because it provides a managed database service with automatic failover to a standby instance in a different Availability Zone, meeting the requirement for minimal downtime. Amazon Aurora does not support SQL Server compatibility; Aurora is MySQL/PostgreSQL-compatible. Amazon EC2 with SQL Server installed is not a managed service, increasing operational overhead. Amazon DynamoDB is a NoSQL database and not compatible with SQL Server, which requires a relational database.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Amazon RDS for SQL Server with Multi-AZ deployment
Why this is correct
Amazon RDS for SQL Server with Multi-AZ deployment provides a managed SQL Server database with automatic failover to a secondary Availability Zone, ensuring minimal downtime and reducing operational overhead.
- ✗
Amazon EC2 with SQL Server installed
Why it's wrong here
Amazon EC2 with SQL Server installed requires manual management of the database, including patching and backups, which does not reduce operational overhead as required.
- ✗
Amazon Aurora SQL Server
Why it's wrong here
Amazon Aurora is not compatible with SQL Server; it supports MySQL and PostgreSQL only. Therefore, it cannot be used for a SQL Server CMS database.
- ✗
Amazon DynamoDB
Why it's wrong here
Amazon DynamoDB is a NoSQL database and does not support SQL Server compatibility or the relational schema required by the CMS database.
Go deeper
Related to this question
About these practice questions
One of 1,616 original PAS-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PAS-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PAS-C01 exam.