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?

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
I would say E is the most appropriate answer as the product catalog has to be sent on a monthly basis.
0
0
what is the correct answer?
0
0
Oh ehm…Jzed? The right answer is A again…but don;t tell anyone!
0
0
I think E as well.
0
0
@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
Explain to jzed what is a disaster please.
0
0
Very handful of web sites that take place to be in depth below, from our point of view are undoubtedly properly really worth checking out.
0
0
Always a huge fan of linking to bloggers that I like but do not get a whole lot of link adore from.
0
0
Wonderful story, reckoned we could combine a couple of unrelated information, nonetheless actually worth taking a appear, whoa did a single find out about Mid East has got extra problerms at the same time
0
0
always a massive fan of linking to bloggers that I enjoy but really don’t get lots of link really like from
0
0
Wonderful story, reckoned we could combine several unrelated information, nevertheless seriously really worth taking a look, whoa did 1 master about Mid East has got extra problerms too
0
0
please check out the sites we comply with, including this 1, as it represents our picks from the web
0
0
we came across a cool website that you simply may possibly take pleasure in. Take a look in the event you want
0
0