X++ Programming Language › Exam MB-500: Microsoft Dynamics 365: Finance and Operations Apps Developer › Question #22548
Single Choice Moderate

Q

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.

ID: #22548 Exam MB-500: Microsoft Dynamics 365: Finance and Operations Apps Developer 105 views
Question Info
#22548Q ID
ModerateDifficulty
Exam MB-500: Microsoft Dynamics 365: Finance and Operations Apps DeveloperTopic
Start Quiz on This Topic
 Your Answer

Choose the Best Option

Click any option to instantly check if you're correct.

  • 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 ✔ ✖
Correct Answer

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

Today: 0 answered · 0 correct
Save progress
Free account

Want to remember what you got wrong?

Create a free account in seconds to track your score, revisit mistakes and continue X++ Programming Language where you left off.

  • Save your progress & streak
  • Topic-wise quizzes & scores
  • Bookmark tricky questions
  • Printable MCQ sets
Sign up free I have an account Next question
Practice smarterFree account · save progress
Sign up free
 Continue Practice
Previous Question Next Question
 Share

Share This Question

Challenge a friend or share with your study group.

 More from This Topic

Related MCQ Questions

You are working on a finance and operations apps implementation in Visual Studio. You have created a new model and now you need to build it. You need to build the model and update the SQL database schema during... You are integrating data from an external system into your Microsoft Dynamics 365 finance and operations apps. The external system provides data in CSV, XML, and tab-delimited formats. You need to import this d... Your company is planning to take a Microsoft application update and apply custom code and configurations to the production environment. You need to reduce the time and cost of user acceptance testing (UAT) with... You are managing data import and export jobs using the Data management workspace. You need to speed up the import of data by enabling parallel processing of importing a file. What should you do?... A developer is working on a Microsoft Dynamics 365 finance and operations apps implementation and needs to add a new field to the CustTable to store additional customer information. You need to add this field w... You are working on a finance and operations app. You have a custom table called BankCheque with two fields BankAccount and CheckNo. You need to run a user interface-driven process to add 100 new check numbers, ... You are enhancing a Microsoft Dynamics 365 finance and operations apps implementation by adding new attributes to certain entities without modifying the existing codebase. You need to extend the functionality o... You are setting up a new Azure DevOps project for the Fleet Management model in Microsoft Dynamics 365 finance and operations apps. The project will host the source code and track changes made by various develo... You are tasked with integrating a legacy inventory management system with Microsoft Dynamics 365 finance and operations apps. The legacy system is capable of sending data in batches and supports RESTful web ser... At your company, you are responsible for optimizing the data integration process for a high-volume e-commerce platform that interacts with Microsoft Dynamics 365 finance and operations apps. The platform experi...