THE FIRST STEP TO ENABLING TDE ON A DATABASE IS TO CREATE A DATABAS...

5. The first step to enabling TDE on a database is to create a database master key

(DMK). Which of the following is the correct syntax for creating a DMK?

A. CREATE MASTER KEY ENCRYPTION BY PASSWORD =

‘somepassword’;

B. ALTER DATABASE tdedatabase SET ENCRYPTION ON;

C. CREATE CERTIFICATE tdeCert WITH SUBJECT = ‘tdeCertificate’;

D. CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM =

AES_256 ENCRYPTION BY SERVER CERTIFICATE tdeCert;

The correct answer is A. Answer B is incorrect because this is the syntax to

start the encryption scan. Answer C is incorrect because this is the syntax used

to create a certificate. Answer D is incorrect because this is the syntax used to

create a database encryption key.