The sales department and the finance department are located in different buildings. The two departments are connected by a 2 megabit network. Both departments use SQL Server 2005.
The sales department records all sales activities in a database named DB1. DB1 contains 380 tables and has a size of 10 GB. The finance department has read-only access to four tables in DB1 for reporting purposes.
The finance department runs queries throughout the day and needs the data to be as up to date as possible. Users in the finance department tell you that report execution is slow.
To optimize network capacity, your department decides to provide copies of these four tables to the finance department. You need to provide copies of these tables.
You want to achieve this goal by using the copy method that uses the least amount of network bandwidth. What should you do?
A.
Mirror DB1 to the finance department. Configure mirroring for high-availability mode.
B.
Establish daily transaction log shipping of DB1 to the finance department. Use the STANDBY option to make the shipped database accessible to reporting.
C.
Establish daily snapshot replication to the finance department. Define a publication that contains the four tables as the only articles.
D.
Establish transactional replication to the finance department. Define a publication that contains the four tables as the only articles.