AZ-305 Practice Question 85: TDE Customer Managed Key

Microsoft Azure Solutions Architect Expert (AZ-305) · Test 9 · question 5 of 10

Data Storage Solutionseasy

A healthcare company stores patient records in an Azure SQL Database. A compliance requirement states that the database's data and log files must be encrypted at rest with a key that the company generates and controls, and that the security team must be able to revoke that key to make the entire database instantly inaccessible, including to Microsoft. The application must keep running unmodified, and queries and indexes on every column must keep working exactly as they do today.

Which solution should you recommend?

Select one answer
Show answer and explanation

Answer:

  • D. Transparent data encryption for the database, configured to use a customer-managed key stored in Azure Key Vault

Transparent data encryption (TDE) encrypts the entire database's data and log files at rest, and it is completely transparent to the application: no query, index, or code change is needed. Using a customer-managed key in Key Vault (bring your own key) means the company generates and owns the key, and disabling or deleting that key immediately makes the database inaccessible to everyone, which satisfies the revocation requirement.

Option A protects specific columns from anyone with database access, including administrators, but randomized encryption breaks equality searches and indexing on those columns, and every query that touches encrypted columns needs application changes, which the scenario rules out.

Option B does not apply to Azure SQL Database, which is a managed platform-as-a-service offering whose storage is not exposed for disk-level encryption tools; TDE is the platform's built-in mechanism for this instead.

Option C requires application code to call encryption and decryption functions explicitly and to manage the symmetric key inside the database, which is both an application change and the opposite of externalizing key control to the company.

Reference: Transparent data encryption for SQL Database, SQL Managed Instance, and Azure Synapse Analytics

Practice Test 9 ›

Study guides for AZ-305