Quiz 70-464

Quiz 70-464, Developing Microsoft SQL Server 2012 Databases

Which statements should you execute?

You need to monitor the health of your tables and indexes in order to implement the required index maintenance strategy

Which three steps should you perform in sequence?

You need to implement security for the restore and audit process

You need to create the usp.AssignUser stored procedure

You need to implement a new version of usp_AddMobileLocation

Which two actions should you perform?

You need to modify the stored procedure usp_LookupConcurrentUsers

You need to redesign the system to meet the scalability requirements of the application

Which task should you use with each maintenance step?