You have an Azure SQL database named DB1. You need to encrypt DB1. The solution must meet the following requirements: - Encrypt data in motion. - Support comparison operators. - Provide randomized…

The correct answer is A. Always Encrypted with secure enclaves. Always Encrypted supports deterministic only for operator comparisons. AE with secure enclaves addresses this limitation. https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted- enclaves?view=sql-server-ver16

Submitted by haru.x· Mar 6, 2026Implement a secure environment

Question

You have an Azure SQL database named DB1. You need to encrypt DB1. The solution must meet the following requirements: - Encrypt data in motion. - Support comparison operators. - Provide randomized encryption. What should you include in the solution?

Options

AAlways Encrypted with secure enclaves
BAlways Encrypted
Ccolumn-level encryption
DTransparent Data Encryption (TDE)

How the community answered

(37 responses)

A
84% (31)
B
3% (1)
C
8% (3)
D
5% (2)

Explanation

Always Encrypted supports deterministic only for operator comparisons. AE with secure enclaves addresses this limitation. https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted- enclaves?view=sql-server-ver16

Topics

#Always Encrypted#secure enclaves#randomized encryption#comparison operators

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice