nerdexam
Microsoft

70-450 · Question #72

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…

The correct answer is B. To finish the task, the NTFS file system security should be utilized and the access of the. The column BonusFIn is of type FILESTFIEAM this means that the data of this column is saved outside of the database on the filesystem. So, you have to protect those files by the NTFS

Design an optimized database solution

Question

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?

Options

  • ATo finish the task, Transparent data encryption should be utilized.
  • BTo finish the task, the NTFS file system security should be utilized and the access of the
  • CTo finish the task, the Trustworthy option for the database should be utilized.
  • DTo finish the task, the Advanced Encryption Standard encryption should be utilized on all

How the community answered

(51 responses)
  • A
    16% (8)
  • B
    75% (38)
  • C
    2% (1)
  • D
    8% (4)

Explanation

The column BonusFIn is of type FILESTFIEAM this means that the data of this column is saved outside of the database on the filesystem. So, you have to protect those files by the NTFS

Topics

#column-level security#data protection#NTFS permissions#unauthorized access prevention

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-450 Practice