Study tips 70-451

Study tips 70-451

You need to design a method for storing large XML-formatted data

You need to rewrite the stored procedure to use a single statement to load the data

What should you recommend?

You need to retrieve all levels by using a single Transact-SQL query

You need to minimize the amount page I/O that is generated when the query runs

You need to ensure that the query retrieves data in minimum possible time

You need to ensure that the query retrieves data in minimum possible time

You need to ascertain that the indexes are used optimally

You need to identify the most likely cause for the problems by analyzing the execution plan

You need to ensure that the query executes as quickly as possible