Administering a SQL Database Infrastructure — Question 73

You administer all the deployments of Microsoft SQL Server 2016 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?

Answer options

• 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 AsynchronousCommit 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 AsynchronousCommit 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

Correct answer: A

Explanation

The correct answer is A because transactional replication allows for near real-time data changes to be sent to another database server while leaving the primary server unaffected. The other options either do not support near real-time data transfer or involve configurations that could impact the primary server's performance or availability.