You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization,optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 instance is managed by you. 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.