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