You administer a SQL Server 2008 instance. The instance hosts a database that contains
sensitive data. You plan to implement a database backup strategy for the database. You
need to ensure that all backups of the database are encrypted. You also need to prevent
unauthorized access of the backups. What should you do?
A.
Use Windows BitLocker Drive Encryption technology.
B.
Use the BACKUP statement along with the MEDIAPASSWORD option.
C.
Use Transparent database encryption.
D.
Use the BACKUP statement along with the PASSWORD option.