Which types of indexes should you use?

DRAG DROP

A company has a Dynamics 365 Finance and Operations 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.

Answer:

Explanation:

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