Administering Relational Databases on Microsoft Azure (DP-300) Test 2
© examsiri.com
Question : 13 of 40
Marks:
+1,
-0
DRAG DROP
You have an Azure SQL database that contains a table named Employees. Employees contains a column named Salary.
You need to encrypt the Salary column. The solution must prevent database administrators from reading the data in the Salary column and must provide the most secure 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
Actions :
1. Encrypt the Salary column by using the randomized encryption type.
2. Create a column encryption key.
3. Enable Transparent Data Encryption (TDE).
4. Encrypt the Salary column by using the deterministic encryption type.
5. Apply a dynamic data mask to the Salary column.
6. Create a column master key.
You have an Azure SQL database that contains a table named Employees. Employees contains a column named Salary.
You need to encrypt the Salary column. The solution must prevent database administrators from reading the data in the Salary column and must provide the most secure 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
Actions :
1. Encrypt the Salary column by using the randomized encryption type.
2. Create a column encryption key.
3. Enable Transparent Data Encryption (TDE).
4. Encrypt the Salary column by using the deterministic encryption type.
5. Apply a dynamic data mask to the Salary column.
6. Create a column master key.
Go to Question: