Which four actions should you perform in sequence?

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:

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



Leave a Reply 2

Your email address will not be published. Required fields are marked *


MarkModel13

MarkModel13

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.

jzed

jzed

is this correct?