Quiz 70-450

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

You need to ensure that the policy is enforced by using Policy-Based Management Framework

You need to assign the least permission necessary to MarketingUser

You need to restrict DBReportsUser to login only between 17:00 hours and 22:00 hours

You need to improve the performance of the application by reducing the I/O performance issue

You need to ensure that the server processes database queries as fast as possible

You need to achieve this goal by ensuring minimum impact of performance on the server

Which two actions should you perform before the upgrade?

You need to ensure that the application executes without deadlocks for the read queries

What collector should you use?

Which action will you perform?