Question 28 of 103 from exam MB-500: Microsoft Dynamics 365: Finance and Operations Apps Developer

Question 28 of 103 from exam MB-500: Microsoft Dynamics 365: Finance and Operations Apps Developer

Prev Question Next Question

Question

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:

Index types Primary Clustered 2 é = g g ry & Answer Area Requirement Provide a unique key for each record in a table. Organize the data for a table according to the physical order of the specified column. Quickly reference data that is found by using a specified set of columns. Index type il

Explanations

Answer Area Index types Requirement Index type Primary Provide a unique key for each record in a table. Primary Clustered Organize the data for a table according to the ° , Clustered physical order of the specified column. Quickly reference data that is found by using a specified set of columns. 2 é = g g ry & Non-Clustered

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.

Prev Question Next Question