- A Create a new index on the FMCustomer extension table that includes the AccountReferrer field.
- B Ensure that the new index is not unique.
- C Modify the existing indexes on the FMCustomer table to include the AccountReferrer field.
- D Option A, B
- Share this MCQ
Answer:
D
Explanation:
Wrong:
Create a unique index on the AccountReferrer field.
Wrong:
Modify the existing indexes on the FMCustomer table to include the AccountReferrer field.
Wrong:
Create a view on the FMCustomer table that includes the AccountReferrer field.
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.
Write extensible tables - Finance & Operations | Dynamics 365 | Microsoft Learn
Add a table extension to a project - Training | Microsoft Learn
Related Topic: