what is the importance of recovery model what is transperent data encryption explain your sql server database expirence why would you use sql agent

Question

Accepted Answer

Recovery model is important for database backup and restore. Transparent data encryption secures data at rest. SQL Agent automates tasks.

Recovery model determines the type of backup and restore strategy to be used.
There are three recovery models: Simple, Full, and Bulk-Logged.
Transparent Data Encryption (TDE) encrypts data at rest and protects against unauthorized access.
TDE uses a symmetric key called the database encryption key (DEK) to encrypt the database.
SQL Agent is used to automate tasks such as backups, maintenance, and alerts.
SQL Agent can also be used to schedule jobs and execute scripts.

Popular interview questions of MS SQL Server Database Administrator