Microsoft
MB-500 · Question #333
MB-500 Question #333: Real Exam Question with Answer & Explanation
Sign in or unlock MB-500 to reveal the answer and full explanation for question #333. The question stem and answer options stay visible for context.
Question
A company uses Dynamics 365 Finance. The company deploys a custom table named LoyaltyCustomerTable. The table has a 1:1 relationship with a table named CustTable. Both tables contain a unique field named AccountNum and share the same data. Using event handlers, all edits to CustTable are reflected within LoyaltyCustomerTable. The LoyaltyCustomerTable data is maintained by using the LoyaltyCustomerTable form. This form selects all data from both LoyaltyCustomerTable and CustTable and displays the records sorted by LoyaltyCustomerTable.AccountNum. LoyaltyCustomerTable was mistakenly created with no indexes. A significant delay occurs when users open the LoyaltyCustomerTable form. You need to improve performance by creating an index. Which method should you use?
Options
- ACreate a foreign key relation on LoyaltyCustomerTable with Related Table set to CustTable and
- BCreate foreign key relation on CustTable with Related Table set to LoyaltyCustomerTable and
- CCreate an index on CustTable for AccountNum.
- DCreate a foreign key relation on LoyaltyCustomerTable with Related Table set to CustTable and
Unlock MB-500 to see the answer
You've previewed enough free MB-500 questions. Unlock MB-500 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.