How to Add a Dedicated Index to an Extended Table in Dynamics 365 F&O?
Table of Contents
Question
You are working on a project that involves the use of Microsoft Dynamics 365 finance and operations apps. You have created an extension of the FMCustomer table and added a new field named AccountReferrer.
You need to add a dedicated index to speed up database searches on AccountReferrer.
What should you do next?
Select only one answer.
A. Create an index in the same manner as you would add an index to a new table.
B. Index the foreign key reference.
C. Add the index to the base table.
D. Set AccountReferrer’s properties to IsMandatory and Unique.
Answer
A. Create an index in the same manner as you would add an index to a new table.
Explanation
Creating an index in the same manner as you would add an index to a new table is the correct approach. Creating a unique index using the extension is not allowed because it is intrusive. Adding the index to the base table is incorrect because the new field was added to the extension, not the base table. Using a third-party tool is not recommended because it may not be compatible with Microsoft Dynamics 365.
Microsoft Dynamics 365: Finance and Operations Apps Developer MB-500 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Microsoft Dynamics 365: Finance and Operations Apps Developer MB-500 exam and earn Microsoft Dynamics 365: Finance and Operations Apps Developer MB-500 certification.