Single Choice Easy

QWhich of the following are valid types of table indexes used in Dynamics AX? (Select all that apply).

ID: #9356 Table Indexes in D365 F&O X++ 248 views
Question Info
#9356Q ID
EasyDifficulty
Table Indexes in D365 F&O X++Topic

Choose the Best Option

Click any option to instantly check if you're correct.

  • A Primary Index
  • B Not Partial Index and A, C, D are correct.
  • C Clustered Index
  • D Non-clustered Index
Correct Answer

Explanation

Justification:

  1. A Primary Index is used to provide a unique key to each record in a table. The allow duplicates property must be set to “No” to prevent duplicate key values
  2. A partial index is not used in Dynamics AX.
  3. A Clustered index is used to determine how data is organized in a table.
  4. A Non-Clustered Index is used to quickly reference data found in the clustered index.

 

Related Lesson: Index Types

Share This Question

Challenge a friend or share with your study group.