Quiz 70-464

Quiz 70-464, Developing Microsoft SQL Server 2012 Databases

You need to perform the following maintenance tasks:

You need to ensure that every time a new row is added to the Orders table, a table that is used for auditing is updated

You need to store validated XML data in Schema1.Table1

What should you set from the index options?

You need to reduce the amount of time it takes to execute Proc1

What should you create?

Which isolation level should you identify?

You need to ensure that usp_GetCustomersByDate completes as quickly as possible

You need to minimize disk contention caused by change data capture

What should you create?