DBS-C01 · Question #225
DBS-C01 Question #225: Real Exam Question with Answer & Explanation
The correct answer is B: Set up Always On Failover Cluster Instances as a single SQL Server instance. Use Multi-AZ. https://docs.aws.amazon.com/prescriptive-guidance/latest/migration-sql-server/ec2-fci.html An FCI is generally preferable over an Always on availability group when: You’re using SQL Server Standard edition instead of Enterprise edition.
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
Explanation
https://docs.aws.amazon.com/prescriptive-guidance/latest/migration-sql-server/ec2-fci.html An FCI is generally preferable over an Always on availability group when: You’re using SQL Server Standard edition instead of Enterprise edition.
Topics
Community Discussion
No community discussion yet for this question.