Microsoft
70-450 · Question #130
70-450 Question #130: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #130. The question stem and answer options stay visible for context.
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?
Options
- AUse Transparent data encryption.
- BUse the Trustworthy option for the database.
- CUse the Advanced Encryption Standard encryption on all columns in the database.
- DUse the NTFS file system security and limit the access of the database files to the SQL
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.