DBS-C01 · Question #225
A company is running a business-critical application on premises by using Microsoft SQL Server. A database specialist is planning to migrate the instance with several databases to the AWS Cloud. The d
Sign in or unlock DBS-C01 to reveal the answer and full explanation for question #225. The question stem and answer options stay visible for context.
Question
A company is running a business-critical application on premises by using Microsoft SQL Server. A database specialist is planning to migrate the instance with several databases to the AWS Cloud. The database specialist will use SQL Server Standard edition hosted on Amazon EC2 Windows instances. The solution must provide high availability and must avoid a single point of failure in the SQL Server deployment architecture. Which solution will meet these requirements?
Options
- ACreate Amazon RDS for SQL Server Multi-AZ DB instances. Use Amazon S3 as a shared
- BSet up Always On Failover Cluster Instances as a single SQL Server instance. Use Multi-AZ
- CSet up Always On availability groups to group one or more user databases that fail over together
- DCreate an Application Load Balancer to distribute database traffic across multiple EC2 instances
Unlock DBS-C01 to see the answer
You've previewed enough free DBS-C01 questions. Unlock DBS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.