QuestionQ113

VerifiedImplement a secure environment

You have an Azure SQL database named DB1 that contains a table with a column named Col1.

You must encrypt the data in Col1. Which four actions should you carry out for DB1, in order?

Drag & Drop
Explanation

This is SQL Server cell/column-level encryption, which uses a fixed key hierarchy: a database master key protects a certificate, the certificate protects a symmetric key, and the symmetric key encrypts the column data. In Azure SQL Database the certificate cannot be created without first having a database master key (unless a password is supplied), so the DMK is the required first step, followed by the certificate, then the symmetric key, and finally the UPDATE that writes ENCRYPTBYKEY values into Col1. 'Create a column master key' is a distractor from the separate Always Encrypted feature. Note the question exposes only four slots; the full Microsoft walkthrough also runs OPEN SYMMETRIC KEY immediately before the UPDATE, but the accepted exam key folds that into the update step and keeps the master-key-first hierarchy, which is the answer scored here.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!