Microsoft 70-462 Exam Study Material

70-462 Question 1


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


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 Asynchronous-Commit 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