You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 instance is managed by you. A new database application is hosted by the instance.
The data security strategy should be designed for the application.
The data should be duplicated to another instance of SQL Server 2008 by utilizing the
Snapshot duplication. Since you are the technical support of the company, you should make sure that all
stored data should be encrypted, and the minimum amount of administrative effort should be utilized.
Which action will you perform?
A.
Encrypted connections should be enabled between the instances.
B.
Transparent data encryption should be enabled for the Publisher, Distribution, and Subscriber databases
C.
Transparent data encryption for the MSDB database should be enabled on the two instances.
D.
Certificate-based encryption should be enabled for the Publisher, Distribution, and Subscriber databases.