You are a professional level SQL Sever 2008 Database Administrator. 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.
Certificate-based encryption should be enabled for the Publisher, Distribution, and
Subscriber databases.
B.
Encrypted connections should be enabled between the instances.
C.
Transparent data encryption should be enabled for the Publisher, Distribution, and
Subscriber databases
D.
Transparent data encryption for the MSDB database should be enabled on the two
instances.