exam questions

Exam MB-500 All Questions

View all questions & answers for the MB-500 exam

Exam MB-500 topic 3 question 1 discussion

Actual exam question from Microsoft's MB-500
Question #: 1
Topic #: 3
[All MB-500 Questions]

DRAG DROP -
A company has a Dynamics 365 Finance environment.
You need to implement indices for new tables.
Which types of indexes should you use? To answer, drag the appropriate types of indexes to the correct requirements. Each type of index may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Primary -

Box 2: Clustered -
A clustered index is a special type of index that reorders the way records in the table are physically stored.

Box 3: Non-clustered -
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
viking1
Highly Voted 1 year, 7 months ago
Correct. However, it is worth noting that a clustered index can contain multiple columns, it is not restricted to a single column.
upvoted 11 times
...
Prollyx
Most Recent 10 months, 1 week ago
Correct
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...