DP-203 · Question #30
You have an Azure Synapse Analytics dedicated SQL pool. You need to ensure that data in the pool is encrypted at rest. The solution must NOT require modifying applications that query the data. What sh
The correct answer is B. Enable Transparent Data Encryption (TDE) for the pool.. Transparent Data Encryption (TDE) helps protect against the threat of malicious activity by encrypting and decrypting your data at rest. When you encrypt your database, associated backups and transaction log files are encrypted without requiring any changes to your applications.
Question
You have an Azure Synapse Analytics dedicated SQL pool. You need to ensure that data in the pool is encrypted at rest. The solution must NOT require modifying applications that query the data. What should you do?
Options
- AEnable encryption at rest for the Azure Data Lake Storage Gen2 account.
- BEnable Transparent Data Encryption (TDE) for the pool.
- CUse a customer-managed key to enable double encryption for the Azure Synapse workspace.
- DCreate an Azure key vault in the Azure subscription grant access to the pool.
How the community answered
(25 responses)- A16% (4)
- B72% (18)
- C8% (2)
- D4% (1)
Explanation
Transparent Data Encryption (TDE) helps protect against the threat of malicious activity by encrypting and decrypting your data at rest. When you encrypt your database, associated backups and transaction log files are encrypted without requiring any changes to your applications. TDE encrypts the storage of an entire database by using a symmetric key called the database encryption key. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-overview-manage-security
Topics
Community Discussion
No community discussion yet for this question.