A company uses Dynamics 365 Finance. The company requires that a custom field named ExternalCustomerId on the table CustTable be added to an index to enhance performance. You need to create the…

The correct answer is C. CustTable.RecId. Note: RecId stands for Record Identifier. It is often called RowId (row identifier). It is a unique and incremental value stored with each and every row of the table. Table index properties The following table describes the properties that are available for indexes on tables…

Design and develop AOT elements

Question

A company uses Dynamics 365 Finance. The company requires that a custom field named ExternalCustomerId on the table CustTable be added to an index to enhance performance. You need to create the index. Which field should you include in the index?

Options

ACustTable.AccountNum
BCustTable.ExternalCustomerId
CCustTable.RecId

How the community answered

(23 responses)

A
17% (4)
B
9% (2)
C
74% (17)

Explanation

Note: RecId stands for Record Identifier. It is often called RowId (row identifier). It is a unique and incremental value stored with each and every row of the table. Table index properties The following table describes the properties that are available for indexes on tables. * AllowDuplicates If you set this property to Yes, the index can be non-unique. If you don't create at least one unique index, a unique index is created by combining the first index and the RecId. * CreateRecIdIndex Specify whether an index on the Record ID field is created. Account numbers fields have the AccountNum data type. https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/dev-ref/application-explorer- https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/extensibility/add-index

Topics

#index creation#RecId#custom field#performance optimization

Community Discussion

No community discussion yet for this question.

Full MB-500 Practice