Quiz 70-450

Quiz 70-450, PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008

Which storage configuration should you use?

Which configuration option should you use?

You need to optimize the performance of the instance

You need to optimize the performance of the database by maximizing disk bandwidth and reducing the contention in the storage allocation structures

You need to design the physical database structure for optimal backup performance

Which two actions should you perform?

You need to ensure that all SSRS reports communicate to the SQL Server instance by using the Kerberos authentication protocol

You need to ensure that the BonusPlan column is protected from unauthorized access by using the most secure method

Which encryption type should you use?

You need to ensure that the application is deployed to the instance without loss of functionality