IT IS VERY IMPORTANT TO BACK UP THE CERTIFICATE WITH THE PRIVATE KE...

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;