You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Marketing department and the Sales department are located in different buildings. However, the two departments are connected by a 2 megabit network. The two departments both make use of SQL Server 2005.
The sales department records all sales activities in a database named Certkiller -DB01. Certkiller -DB01 consists of 380 tables and has a size of 10 GB. The marketing department has read-only access to four tables in Certkiller -DB01. This is for reporting purposes. Queries are run by the marketing department throughout the day. The marketing department requires that the data be as current as possible.
You have received several complaints from the users in the marketing department informing you that the report execution is slow. In order to optimize network capacity the CIO decides to provide copies of these four tables to the marketing department. You request that you are supplied with copies of these tables. You need to accomplish this objective by using the copy method that makes use of the minimum network bandwidth.
What should you do?
A.
You need to set up daily transaction log shipping of Certkiller -DB01 to the marketing department.
Thereafter she can make use of the STANDBY option to make the shipped database accessible to reporting.
B.
You need to establish Transactional replication be to the marketing department.
Then you can define a publication that contains the four tables as the only articles.
C.
You need to establish daily snapshot replication to the marketing department.
Thereafter you should define a publication that contains the four tables.
D.
You need to mirror Certkiller -DB01 to the marketing department.
Thereafter she can configure mirroring for high-availability mode.
Explanation:
A mirror is in a recovering state, not allowing any connections, so it is not an option in this case. Daily transaction log shipping or snapshot replications are to slow to apply to the "as up to date as possible" part of the scenario.