MCQ PracticeSingle Best AnswerTopic: Module 7: Table Indexes
Q
Which of the following are valid types of table indexes used in Dynamics AX? (Select all that apply).
Question ID
#9356
Subchapter
Module 7: Table Indexes
Action
Choose one option below
Choose Your Answer
Click an option to check whether your answer is correct.
A
Primary Index ✔✖
B
Not Partial Index and A, C, D are correct. ✔✖
C
Clustered Index ✔✖
D
Non-clustered Index ✔✖
B
Correct Answer: B
Explanation
Justification:
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
A partial index is not used in Dynamics AX.
A Clustered index is used to determine how data is organized in a table.
A Non-Clustered Index is used to quickly reference data found in the clustered index.