You administer a SQL Server 2008 instance. You plan to design the security requirements
for a new database application that will be deployed to the instance. The new database
contains a table that is created by using the following code segment: CREATE TABLE
EmpBonusPlan ( EmployeeID INT NOT NULL IDENTITY(1,1), NumOptions INT NOT NULL,
BaseSalary MONEY NOT NULL, BonusPlan VARBINARY(MAX) FILESTREAM ) You need
to ensure that the BonusPlan column is protected from unauthorized access by using the
most secure method. What should you do?
A.
Use Transparent data encryption.
B.
Use the NTFS file system security and limit the access of the database files to the SQL
Server 2008 Service account.
C.
Use the Trustworthy option for the database.
D.
Use the Advanced Encryption Standard encryption on all columns in the database.
Explanation: