You administer a Microsoft SQL Server 2012 instancethat contains a database of confidential data.
You need to encrypt the database files at the page level.
You also need to encrypt the transaction log files.
Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of
actions to the answer area and arrange them in the correct order.)
Build List and Reorder:
Answer:
Explanation:
Reference: http://msdn.microsoft.com/en-us/library/bb510663.aspx
Reference: http://msdn.microsoft.com/en-us/library/bb934049.aspx
1. Create a master key.
2. Create a certificate in the master database protected by master key.
3. Create database encryption key in the user database and protect it by certificate.
4. Set the database option to enable enctyption.
is this correct?