Exam 70-761 topic 1 question 150 discussion

Actual exam question from Microsoft's 70-761

Question #: 150
Topic #: 1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are creating indexes in a data warehouse.
You have a dimension table named Table1 that has 10,000 rows. The rows are used to generate several reports.
The reports join a column that is the primary key.
The execution plan contains bookmark lookups for Table1.
You discover that the reports run slower than expected.
You need to reduce the amount of time it takes to run the reports.
Solution: You create a nonclustered index on the primary key column that includes the bookmark lookup columns.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️

by flashed at Feb. 8, 2020, 10:13 p.m.

Comments

Submit Cancel

flashed

Highly Voted 5 years, 3 months ago

Why can't? I think that should be A. Yes.

upvoted 14 times

...

supermario

Highly Voted 5 years, 2 months ago

yes. this is A. Yes the answer for previous would be NO. The data comes directly from the Index

upvoted 7 times

Anette

4 years, 11 months ago

Server Query Optimizer decides to use the clustered index to retrieve the requested data, as it is more efficient, much faster and fewer resources consumer than scanning the whole table, in addition to having the data sorted in the index pages. This is NO, and previous is YES

upvoted 5 times

...

Vermonster

Most Recent 4 years, 4 months ago

A - with a nonclustered index including the key lookup fields, you have a covering index which is faster

upvoted 2 times

...

getstoopid

4 years, 8 months ago

I think it is yes and the previous also yes since the join criteria is the primary key and therefor the clustered index useful as additional lookups aren't necessary anymore

upvoted 1 times

...

MarcusJB

5 years, 2 months ago

I'd also say that it should at least be faster than before because the query doesn't have to read data from the table itself but just from the index. As far as there are not so many columns to include this could be a possible option to gain performance.

upvoted 3 times

...

Exam 70-761 All Questions

View all questions & answers for the 70-761 exam