nerdexam
Microsoft

DP-300 · Question #108

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 A. Transparent Data Encryption (TDE). Transparent data encryption (TDE) helps protect Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics against the threat of malicious offline activity by encrypting data at rest…

Submitted by marco_it· Mar 6, 2026Implement a secure environment

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

  • ATransparent Data Encryption (TDE)
  • BAdvanced Data Security for this database
  • CAlways Encrypted for all columns
  • DSecure transfer required

How the community answered

(27 responses)
  • A
    93% (25)
  • C
    4% (1)
  • D
    4% (1)

Explanation

Transparent data encryption (TDE) helps protect Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics against the threat of malicious offline activity by encrypting data at rest. https://docs.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice