PrepAway - Latest Free Exam Questions & Answers

Which configuration should you use?

You administer all the deployments of Microsoft SQLServer 2012 in your company.
A database contains a large product catalog that isupdated periodically.
You need to be able to send the entire product catalog to all branch offices on a monthly basis.
Which configuration should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
� 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

B.
� SQL Server that includes an application database configured to perform
transactional replication

C.
� 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

D.
� Two servers configured in a Windows Failover Cluster in the same data center
� SQL Server configured as a clustered instance

E.
� SQL Server that includes an application database configured to perform snapshot
replication

F.
� Two servers configured in different data centers
� SQL Server Availability Group configured in Synchronous-Commit Availability
Mode
� One server configured as an Active Secondary

G.
� Two servers configured on the same subnet
� SQL Server Availability Group configured in Synchronous-Commit Availability
Mode

H.
� Two servers configured in different data centers
� SQL Server Availability Group configured in Asynchronous-Commit Availability
Mode

Explanation:
I think that i’ll stick with “E” as that was the original answer and “You need to be able to send the entire
product catalog to all branch offices on a monthly basis. ” definatly sounds like it wants snapshot

13 Comments on “Which configuration should you use?

  1. Yalose says:

    @jzed Answer is A for sure. Because you need to put all the secondary servers in the same data center. In the case of disaster, the server will continue working.




    0



    0

Leave a Reply