MCQ Single Best Answer Easy

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

ID: #9356 Module 7: Table Indexes 227 views
Question Info
#9356Q ID
EasyDifficulty
Module 7: Table IndexesTopic

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: Option B

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.