🔥 3-day streak
Microsoft Azure Database Administrator Associate7 / 144
Question 7 of 144

You are implementing Always Encrypted (without secure enclaves) on an Azure SQL Database. The Customers table has two sensitive columns: SSN, which must support equality lookups in WHERE clauses and be used as a join key, and MedicalNotes, which is only ever displayed and never filtered. You want the strongest encryption that still satisfies the application's query requirements for each column. Which encryption type should you assign to each column?

Reviewed for accuracy · Report an issueNext question