MB-500: Microsoft Dynamics 365: Finance and Operations Apps DeveloperDemo

By Microsoft · Question Mode

QuestionQ62

Implement security and optimize performance

A company has a Dynamics 365 Finance environment.

You need to implement indexes for new tables.

Which index types should you use? Each index type may be used once, more than once, or not at all.

Drag & Drop
Primary
Clustered
Non-Clustered
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.
Explanation

A primary key uniquely identifies each record. A clustered index sorts and stores the table’s data rows by its key values, defining their physical order. A nonclustered index is maintained separately from the data rows and contains key values plus row locators, enabling efficient lookups by its specified columns.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!