You work as a database administrator at ABC.com. ABC.com is using SQL Server 2008.
ABC.com has laboratory for analyzing new products. The results of the analysis are stored on a
SQL Server 2008 server named ABC_LAB that is in the laboratory. You have received instructions
ensure thatdata on ABC_LAB is replicated to the production SQL Server 2008 servers outside the
laboratoryso that the data can be used for reporting.
How would you accomplish this task? (Each correct answer forms part of the solution. Choose
TWO.)
A.
You should consider using a separate transactional publication on ABC_LAB.
B.
You should consider using a separate snapshot publication on ABC_LAB.
C.
You should consider developing a merge subscription on each production SQL Server 2008
servers outside the laboratory.
D.
You should consider using a push subscription on ABC_LAB.
E.
You should consider using a pull subscription on each production SQL Server 2008 servers
outside the laboratory.
Explanation: