What is a weakness of Transparent Data Encryption (TDE) in Azure SQL Database?
Experience Level: Senior
Tags: Azure CloudAzure SQL Database
Answer
TDE protects only data at rest. When data is loaded into memory, it is decrypted and accessible to administrators (DBAs) and can be used by all roles and applications that have access to the database. So if there are any sensitive data in columns that need to be protected from administrator roles and remain encrypted in memory, Transparent Data Encryption (TDE) won't help you.
s
Related Azure Cloud job interview questions
According to Microsoft Cloud Adoption Framework (CAF), what are the three specific terms related to Management phaze that can help improve conversations among business stakeholders?
Microsoft Cloud Adoption Framework (CAF) JuniorWhat are 6 key steps for establishing a management baseline according to Microsoft Cloud Adoption Framework (CAF)?
Microsoft Cloud Adoption Framework (CAF) JuniorWhat is management baseline according to Microsoft Cloud Adoption Framework (CAF)?
Microsoft Cloud Adoption Framework (CAF) JuniorWhat are the 5 disciplines of cloud governance according to Microsoft Cloud Adoption Framework (CAF)?
Microsoft Cloud Adoption Framework (CAF) JuniorIs Cloud Security Posture Management (CSPM) available for all Azure Subscriptions?
Microsoft Defender Junior