Which configuration should you use?

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?
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 standby

View Answer

Answer: A

Explanation:

SQL Server supports the following heterogeneous scenarios for transactional and snapshot replication:

– Publishing data from SQL Server to non- SQL Server Subscribers.

– Publishing data to and from Oracle has some restrictions.

References: https://docs.microsoft.com/en-us/sql/relational-databases/replication/non-sql/heterogeneous­database-replication