Home » Microsoft » 70-764 v.2 » Which three actions should you perform in sequence?
DRAG DROP
You have a database named DB1.
You need to encrypt two columns in DB1 by using column-level encryption.
Which three 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.
Select and Place:
Correct Answer:
Explanation/Reference:
Explanation:
Step 1: You must have a database master key. If your database does not already have a database master key, create one.
Step 2: Create a certificate.
Step 3: Create a symmetric key.
References: https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/encrypt-a-column-of-data