多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

You are a professional level SQL Sever 2008 Database Administrator in an international  corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 instance is managed by you. 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:  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.
正确答案:B
答案解析:
进入题库查看解析

微信扫一扫手机做题