How to Optimize Database Searches for Extended Fields in Dynamics 365 F&O?
Table of Contents
Question
You have extended the FMCustomer table to include a new AccountReferrer field.
You need to ensure that database searches involving the new field are optimized.
What should you do? Each correct answer presents part of the solution. Choose two.
Select all answers that apply.
A. Create a unique index on the AccountReferrer field.
B. Modify the existing indexes on the FMCustomer table to include the AccountReferrer field.
C. Create a new index on the FMCustomer extension table that includes the AccountReferrer field.
D. Ensure that the new index is not unique.
E. Create a view on the FMCustomer table that includes the AccountReferrer field.
Answer
C. Create a new index on the FMCustomer extension table that includes the AccountReferrer field.
D. Ensure that the new index is not unique.
Explanation
Creating a new index on the extended table that includes the new field will optimize database searches. The index should not be unique as this is intrusive and not allowed in extensions. Modifying existing indexes or creating a view does not directly optimize searches on the new field.
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.