Have you failed a job interview?
Send us your job interview questions and get correct answers.

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

Comments

No Comments Yet.
Be the first to tell us what you think.
Azure SQL Database
Azure SQL Database

Are you learning Azure Cloud ? Try our test we designed to help you progress faster.

Test yourself
AZ-304 Microsoft Azure Architect Design Preparation
AZ-304 Microsoft Azure Architect Design Preparation

Are you learning Azure Cloud ? Try our test we designed to help you progress faster.

Test yourself