PrepAway - Latest Free Exam Questions & Answers

Which configuration should you use?

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?

PrepAway - Latest Free Exam Questions & Answers

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

11 Comments on “Which configuration should you use?


Leave a Reply