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.
what is the correct answer?
Oh ehm…Jzed? The right answer is A again…but don;t tell anyone!
I think E as well.
@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.
Explain to jzed what is a disaster please.
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.
Always a huge fan of linking to bloggers that I like but do not get a whole lot of link adore from.
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
always a massive fan of linking to bloggers that I enjoy but really don’t get lots of link really like from
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
please check out the sites we comply with, including this 1, as it represents our picks from the web
we came across a cool website that you simply may possibly take pleasure in. Take a look in the event you want