You are the administrator of the ACME banking group. You are responsible for security on the Azure SQL database called SQL_DB_Main. The requirement from the auditors is that all data in the database needs to be encrypted as rest. Which encryption technology should be used?
Transparent Data Encryption is correct as it is intended to add a layer of security to protect data at rest from offline access to raw files or backups. Always Encrypted is used for encrypted in transit and prevent database admins from viewing sensitive data in the database.