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?

Question

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?

Accepted Answer

D. Use the NTFS file system security and limit the access of the database files to the SQL

Answer

A. Use Transparent data encryption.

Answer

B. Use the Trustworthy option for the database.

Answer

C. Use the Advanced Encryption Standard encryption on all columns in the database.

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…

Question

Options

How the community answered

Community Discussion