You are a professional level SQL Sever 2008 Database Administrator. A database is hosted
by the instance, and sensitive data is included in the database. A database backup strategy
will be implemented for the database. You need to have all backups of the database
encrypted. The backups should not be accessed by unauthorized users. Which action will
you perform?
A.
Transparent database encryption should be utilized.
B.
Windows BitLocker Drive Encryption technology should be utilized.
C.
The BACKUP statement should be utilized along with the PASSWORD option.
D.
The BACKUP statement should be utilized along with the MEDIAPASSWORD option.