How should you complete the Transact-SQL statement?

Posted by: Pdfprep Category: 70-767 Tags: , ,

HOTSPOT

You manage an inventory system that has a table named Products. The Products table has several hundred columns.

You generate a report that relates two columns named ProductReference and ProductName from the Products table. The result is sorted by a column named QuantityInStock from largest to smallest.

You need to create an index that the report can use.

How should you complete the Transact-SQL statement? To answer, select the appropriate Transact-SQL segments in the answer area.

Answer:

Leave a Reply

Your email address will not be published.