You administer a SQL Server 2008 instance. The instance hosts a new database
application. You plan to design the data security strategy for the application. You will use
Snapshot replication to replicate the data to another instance of SQL Server 2008. You
need to ensure that all stored data is encrypted by using the least amount of administrative
effort. What should you do?
A.
Enable encrypted connections between the instances.
B.
Enable Transparent data encryption for the MSDB database on the two instances.
C.
Enable Transparent data encryption for the Publisher, Distribution, and Subscriber
databases.
D.
Enable certificate-based encryption for the Publisher, Distribution, and Subscriber
databases.