nerdexam
Microsoft

DP-203 · Question #135

You have a data warehouse in Azure Synapse Analytics. You need to ensure that the data in the data warehouse is encrypted at rest. What should you enable?

The correct answer is B. Transparent Data Encryption (TDE). Azure SQL Database currently supports encryption at rest for Microsoft-managed service side and client-side encryption scenarios. Support for server encryption is currently provided through the SQL feature called Transparent Data Encryption. Client-side encryption of Azure SQL Da

Submitted by krish.m· Mar 30, 2026Secure, monitor, and optimize data storage and data processing

Question

You have a data warehouse in Azure Synapse Analytics. You need to ensure that the data in the data warehouse is encrypted at rest. What should you enable?

Options

  • AAdvanced Data Security for this database
  • BTransparent Data Encryption (TDE)
  • CSecure transfer required
  • DDynamic Data Masking

How the community answered

(32 responses)
  • A
    19% (6)
  • B
    69% (22)
  • C
    3% (1)
  • D
    9% (3)

Explanation

Azure SQL Database currently supports encryption at rest for Microsoft-managed service side and client-side encryption scenarios. Support for server encryption is currently provided through the SQL feature called Transparent Data Encryption. Client-side encryption of Azure SQL Database data is supported through the Always Encrypted https://docs.microsoft.com/en-us/azure/security/fundamentals/encryption-atrest

Topics

#Transparent Data Encryption#TDE#encryption at rest#Synapse Analytics

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice