Designing an Azure Data Solution (legacy) — Question 3

A company stores sensitive information about customers and employees in Azure SQL Database.
You need to ensure that the sensitive data remains encrypted in transit and at rest.
What should you recommend?

Answer options

Correct answer: B

Explanation

The correct answer is B because Always Encrypted with secure enclaves provides encryption for sensitive data both in transit and at rest, ensuring maximum protection. Option A, Transparent Data Encryption, only secures data at rest, while options C and D do not directly address encryption for Azure SQL Database.