nerdexam
MicrosoftMicrosoft

DP-300 · Question #274

DP-300 Question #274: Real Exam Question with Answer & Explanation

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, 2026

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)

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

Community Discussion

No community discussion yet for this question.

Full DP-300 PracticeBrowse All DP-300 Questions