Quiz 70-431

Quiz 70-431, TS: Microsoft SQL Server 2005 – Implementation and Maintenance

What should you do to partition the information in order to increase performance and optimize maintenance of the CK_Sales database?

What should you do to add a key column to an existing clustered index on the OrderDetails table?

What should you do to provide maximum query performance?

What should you do to enforce the values that the SalesPersonID column in the Invoices table will accept?

What should you do to ensure that combination of the DateShipped, ProductID and InvoiceID is unique for each row in the Inventory table?

What should you do to this solution to be available for reuse in Transact-SQL statements and views?

What should you do to the second trigger to execute once the first trigger is executed?

What should you do to ensure that the view cannot be affected by modifications to underlying table schemas?

What should you do to add this new column by using the least amount of effort?

What should you do to improve the performance of the stored procedures?