单项选择题
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.
单项选择题 You administer a SQL Server 2008 Reporting Services (SSRS) instance. You plan to design an authentication method for SSRS reports that use SQL Server data connections. You need to ensure that all SSRS reports communicate to the SQL Server instance by using the Kerberos authentication protocol. What should you do?（）
多项选择题 You administer a SQL Server 2008 instance. You deploy a new database named Engineering. The Engineering database manages large documents that will be revised occasionally. You need to design a table structure that allows fast read access. You also need to minimize storage space requirements. Which two actions should you perform?（）
单项选择题 You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（）
You need to ensure that the BonusPlan column is protected from unauthorized access by using the most secure method.