Single Choice Easy

QAn index is an important element that is added to a table. Which of the following statements is true regarding indices?

ID: #9659 Table Indexes in D365 F&O X++ 235 views

Question Info

#9659Q ID

EasyDifficulty

Table Indexes in D365 F&O X++Topic

Start Quiz on This Topic

Your Answer

Choose the Best Option

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

A The order of columns in an index is not important. ✔ ✖
B A primary index should have the “Allow Duplicates” property set to “Yes.” ✔ ✖
C A non-clustered index organizes data in a table according to the order of the index. ✔ ✖
D An index is used to improve the speed of data retrieval. ✔ ✖

Correct Answer

A. Incorrect: The order of columns in an index is important and should be organized from most to least granular.
B. Incorrect: A primary index should have the “Allow Duplicates” property set to “No” because it is a unique key.
C. Incorrect: A clustered index, not a non-clustered index, organizes data in a table according to the order of the index.
D. Correct: The main purpose of an index is to increase the speed of retrieving data.

Continue Practice

Previous Question No Next

Challenge a friend or share with your study group.