Have you failed a job interview?
Send us your job interview questions and get correct answers.
What is Transparent Data encryption for Azure SQL Database?
Experience Level: Senior
Tags: Azure CloudAzure SQL Database
Answer
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. It performs real-time encryption and decryption of the database, associated backups, and transaction log files at rest without requiring changes to the application. By default, TDE is enabled for all newly deployed Azure SQL Databases and must be manually enabled for older databases of Azure SQL Database. For Azure SQL Managed Instance, TDE is enabled at the instance level and newly created databases. TDE must be manually enabled for Azure Synapse Analytics.
Related Azure Cloud job interview questions
What is Azure Disk Encryption?
Azure CloudAzure StorageAzure Virtual Machines SeniorWhat is Dynamic Data masking in Azure SQL Database?
Azure CloudAzure SQL Database SeniorWhat is Always Encrypted in Azure SQL Database?
Azure CloudAzure SQL Database SeniorYou need to create Azure resources for multiple departments. How will you organize the resources so that you can then generate a consolidated view of costs that displays cost broken down by department?
Azure CloudAzure Resource Manager SeniorYou plan to copy 1TB of data files to Azure Blob storage. What storage type would you recommend to minimize the cost, support storage tiers and be available if a single data center fails?
Azure CloudAzure Storage Senior