WHICH SQL SERVER PERMISSIONS ARE REQUIRED TO ENABLE TRANSPARENT DAT...

4. Which SQL Server permissions are required to enable transparent data

encryption (TDE)?

A. Permissions associated with creating the user database.

B. Permissions associated with making server-level changes.

C. Permissions associated with creating a database master key and certificate in

the master database and control permissions on the user database.

D. Permissions associated with the operating system administrator’s account.

The correct answer is C. Answers A, B and D are incorrect since they do

not supply the appropriate level of permissions needed in order to enable

TDE.