Microsoft MB6-890 Question Answer

You have two tables named Table l and Table2. There is a many to one relationship between Table2 and Table l. You discover that following X++ statement is very
slow to execute;

 

Table l field cannot have duplicate data in Table 1
You need to reduce the amount of time it takes for the code to execute.
What should you create?

A. A unique index in table 1 Field and a unique index in table2.ref Field
B. A non-unique index in table 1 Field and a unique index in table2.refField
C. A unique index in table 1 Field and a non-unique index in table2 ref Field
D. A non-unique index in table 1 Field and a non-unique index in table2 ref Field

Answer: C