You are a professional level SQL Sever 2008 Database Administrator. 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.