PrepAway - Latest Free Exam Questions & Answers

What should you do?

You work as a database administrator at Domain.com. Domain.com is using SQL Server 2008
for its database administration. Domain.com has five automated testing areas for completely assembled items.
The Testing results of every area are stored on the SQL Server 2008 instance.
You have received instructions to create a replication method to ensure that test results flow from
the testing areas to the SQL Server efficiently and that it can be used for reporting.

What should you do? (Each correct answer forms part of the solution. Choose TWO.)

PrepAway - Latest Free Exam Questions & Answers

A.
You should consider developing a separate transactional publication at every testing area for the test results.

B.
You should consider developing a separate snapshot publication at every testing area for the test results.

C.
You should consider developing a merge subscription on each distributor to the SQL Server.

D.
You should consider developing a push subscription on each testing area.

E.
You should consider developing a pull subscription on each distributor to the SQL Server.


Leave a Reply