Administering a SQL Database Infrastructure — Question 72
You administer all the deployments of Microsoft SQL Server 2016 in your company.
You need to ensure that an OLTP database that includes up-to-the-minute reporting requirements can be off- loaded from the primary database to another server.
You also need to be able to add indexes to the secondary database.
Which configuration should you use?
Answer options
- A. Two servers configured in different data centers SQL Server Availability Group configured in Synchronous-Commit Availability Mode One server configured as an Active Secondary
- B. 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
- C. 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
- D. Two servers configured in different data centers SQL Server Availability Group configured in AsynchronousCommit Availability Mode
- E. Two servers configured on the same subnet SQL Server Availability Group configured in Synchronous-Commit Availability Mode
- F. SQL Server that includes an application database configured to perform transactional replication
- G. SQL Server that includes an application database configured to perform snapshot replication
- H. Two servers configured in a Windows Failover Cluster in the same data center SQL Server configured as a clustered instance
Correct answer: F
Explanation
The correct answer is F because transactional replication allows for real-time data transfer to a secondary database, which meets the requirement for immediate reporting. The other options do not provide the necessary real-time offloading or the ability to add indexes to the secondary database as needed.