6. It is very important to back up the Certificate with the private key once it has
been created and to copy it to a secure location other than on the server that
it was created on. Which of the following is the correct syntax to back up a
Certificate?
A. CREATE CERTIFICATE tdeCert WITH SUBJECT = ‘tdeCertificate’;
B. BACKUP CERTIFICATE tdeCert TO FILE = ‘path_to_file’ WITH
PRIVATE KEY ( FILE = ‘path_to_private_key_file’, ENCRYPTION BY
PASSWORD = ‘cert password’);
C. CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM =
AES_256 ENCRYPTION BY SERVER CERTIFICATE tdeCert;
D. ALTER DATABASE tdedatabase SET ENCRYPTION ON;
Bạn đang xem 6. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P146 PPS