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.
Bạn đang xem 5. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P146 PPS