Question:Which of the following is the correct order of steps to be followed while using the Transparent Data Encryption security feature of SQL Server 2008? 

A 1. Create a database encryption key. 
2. Create or obtain a certificate protected by the encryption key. 
3. Create a master key and protect it by the certificate. 
4. Set the database to use encryption. 
B 1. Create a database encryption key. 
2. Create a master key. 
3. Create or obtain a certificate protected by the master key. 
4. Set the database to use encryption. 
C 1. Create a master key. 
2. Create or obtain a certificate protected by the master key. 
3. Create a database encryption key and protect it by the certificate. 
4. Set the database to use encryption. 
D None of these 

+ Answer
C 

+ Report

Mohammad Towhidul Islam

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description