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.
Community Discussion