Exam 70-767 topic 1 question 18 discussion

Actual exam question from Microsoft's 70-767

Question #: 18
Topic #: 1

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.
Hot Area:

Show Suggested Answer

Suggested Answer:

by Jrestrepo at May 21, 2020, 12:22 a.m.

Comments

Submit Cancel

JHJHJHJHJ

4 years, 5 months ago

Answer provided by the question is correct

upvoted 1 times

...

Slava_bcd81

4 years, 8 months ago

the answer doesn't fit the question - as Products table doesn't have Quantity column

upvoted 2 times

Slava_bcd81

4 years, 8 months ago

the answer should be: -nonclustered (as the table is too big to use clustered index, 100 columns) -ProductReference -ProductName

upvoted 2 times

Tinashe16

4 years, 6 months ago

This answer doesnt make sense.

upvoted 4 times

Tinashe16

4 years, 6 months ago

The answer provided in the question is correct as is.

upvoted 2 times

...

Jrestrepo

5 years, 1 month ago

I thought Clustered Indexes were more efficient. Does anybody know the difference between a clustered index and a nonclustered index?

upvoted 2 times

Jrestrepo

5 years, 1 month ago

For those interested, I found the following info. on the differences between clustered and nonclustered indexes: There can be only one clustered index per table. However, you can create multiple non-clustered indexes on a single table. Clustered indexes only sort tables. Therefore, they do not consume extra storage. Non-clustered indexes are stored in a separate place from the actual table claiming more storage space. Clustered indexes are faster than non-clustered indexes since they don’t involve any extra lookup step.

upvoted 1 times

tubis

5 years ago

Clustered Index is used when you are working with the key of the table. Since in this scenario, they want to order it by StockQuantity which is not a key, we should create a nonclustered index and include those columns which we want to return in the select part

upvoted 8 times

...