Question

TRANSPARANT DATA ENCRYPTION TOPIC INTRODUCTION 150WORDS, DESCRIPTION 250 WORDS,  CONCLUTION 150 WORDS USE OWN WORDS 500 WORDS. WITH REFERENCE SAFEASSIGN NEEDED

Answer 1

Transparent Data Transfer or TDE is also known as encryption of data at rest. It encrypts Azure SQL DB, SQL server. To protect our data, we may store it using security measures, using encryption , or using firewall or designing a system which is secure. But, in scenerios where tha data is in physical assets like hard disk or pen drive or backup tapes, these kind of data sources can be stolen and the data is at high risk. So, in such a scenerio we can encrypt the data present in the database and then secure the key used for encryption with a certificate. this is where Transparent Data Transfer comes into picture.

TDE is used to implement Input/Output encryption and decryption on the data files in real time.The key used for encryption here is stored in the database record which can be accessed be during decrypting. This key is called Database Encryption Key, DEK in short. Now this key is secured with a certificate which is present in the server's master database. It protects the data files and logs also. This is used for implementing encryption techniques like AES and 3DES. It helps in complying with various regulations and rules required in industries. It is useful to protect data which in not in transit but at rest, like backup files or files in general.

There are some restrictions involved in TDE and these operations are not allowed like drop the DB, or take the DB offline, change the database into Read only mode.