Microsoft Exam Questions

Which configuration should you use?

You administer all the deployments of Microsoft SQLServer 2012 in your company.
You need to ensure that data changes are sent to a non-SQL Server database server in
near real time.
You also need to ensure that data on the primary server is unaffected.
Which configuration should you use?

A.
� SQL Server that includes an application database configured to perform
transactional replication

B.
� Two servers configured in different data centers
� SQL Server Availability Group configured in Asynchronous-Commit Availability
Mode

C.
� Two servers configured in different data centers
� SQL Server Availability Group configured in Synchronous-Commit Availability
Mode
� One server configured as an Active Secondary

D.
� SQL Server that includes an application database configured to perform snapshot
replication

E.
� Two servers configured in the same data center
� SQL Server Availability Group configured in Asynchronous-Commit Availability
Mode
� One server configured as an Active Secondary

F.
� Two servers configured on the same subnet
� SQL Server Availability Group configured in Synchronous-Commit Availability
Mode

G.
� Two servers configured in a Windows Failover Cluster in the same data center
� SQL Server configured as a clustered instance

H.
� Two servers configured in the same data center
� A primary server configured to perform log-shipping every 10 minutes
� A backup server configured as a warm standby

Explanation:
Original Answer is A and I’ll agree as it’s the only one using Transactional Replication.
Must be to do with “You need to ensure that data changes are sent to a non-SQL Serverdatabase server in
near real time. “