Pass4sure 70-462 Question Answer

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

Answer: F

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

Answer: A