Home » Microsoft » 70-473 v.2 » Which sequence should you execute the code blocks?
DRAG DROP
You have a Microsoft Azure SQL database named Database1.
You need to implement the Always Encrypted feature for Database1.
In which sequence should you execute the code blocks? To answer, move all the code blocks from the list of code blocks to the answer area and arrange them in the correct order.
Select and Place:
Correct Answer:
Explanation/Reference:
Explanation:
Step 1 (Box 1-Box 2): Create a column master key in a key store.
Syntax:
CREATE COLUMN MASTER KEY key_name
WITH (
KEY_STORE_PROVIDER_NAME = ‘key_store_provider_name’, KEY_PATH = ‘key_path’
) [;]
Step 2 (box 3-5): Create a column encryption key
The following example creates a column encryption key called MyCEK.
CREATE COLUMN ENCRYPTION KEY MyCEK
WITH VALUES
(
COLUMN_MASTER_KEY = MyCMK, ALGORITHM = ‘RSA_OAEP’,
ALGORITHM = ‘RSA_OAEP’, ENCRYPTED_VALUE = xx
);
GO
References:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-column-master-key-transact-sql?view=sql-server-2017 https://docs.microsoft.com/en-us/sql/t-sql/statements/create-column-encryption-key-transact-sql?view=sql-server-2017