试题详情
单项选择题 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: 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 Trustworthy option for the database. 

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

D、Use the NTFS file system security and limit the access of the database files to the SQL Server 2008 Service account.

  • D
  • 关注下方微信公众号,在线模考后查看

热门试题