42

Note: This question is 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 deploying a Microsoft SQL Server architecture to support a new mission-critical application. The application includes a dedicated reporting component that performs read-only operation

s against the application-s databases.

You need to implement a solution that meets the following requirements:

Provide maximum uptime for the databases.

Include automatic failover in the event of a hardware problem on the primary server.

Separate the re

porting workload from the read/write transactional processing workload and contain real-time data.

Modifications to the application to support the new architecture are not permitted.

What 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 SQL Server failover cluster instance (FCI)

F. a Windows Cluster with a shared-nothing architecture

G. an Always On Availability gro

up with secondary replicas in asynchronous-commit mode

Synchronous-commit mode emphasizes high availability over performance, at the cost of increased transaction latency.

References: https://docs.microsoft.com/en-us/sql/database-engine/availab

ility-groups/windows/availability-modes-always-on-availability-groups?view=sql-server-2017