Note: This question is a part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are designing a new disaster recovery (DR) solution for a heavily-utilized application database. The DR site is in a remote datacenter. You should minimize network traffic to the DR site during business hours.
You need to deploy a solution that allows near-real time queries to be run on the secondary instance and
minimizes the effect on performance for the main production database.
Which should you implement?
A . A Microsoft Azure Stretch Database
B . log shipping
C . an Always On Availability Group with all replicas in synchronous-commit mode
D . a file share witness
E . a Microsoft SQL Server failover cluster instance (FCI)
F . a Windows Cluster with a shared-nothing architecture
G . an Always On Availability Group with secondary replicas in asynchronous-commit mode
Answer: C
Explanation:
Synchronous-commit mode emphasizes high availability over performance, at the cost of increased transaction latency.
Leave a Reply