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. The security requirements should be designed for a new database application,
and the application will be deployed to the instance.
A table is consisted by the new database, and the table is created by utilizing the following code segment:
TABLE EmpBonusPlan
Since you are the technical support, you should utilize the maximum secure method to protect the
BonusPlan column from the access of unauthorized users. Which action will you perform to finish the task?
A.
To finish the task, Transparent data encryption should be utilized.
B.
To finish the task, the NTFS file system security should be utilized and the access of the database files should be limited to the SQL Server 2008 Service account.
C.
To finish the task, the Trustworthy option for the database should be utilized.
D.
To finish the task, the Advanced Encryption Standard encryption should be utilized on all columns in the database.