Q:
The development team is tasked with improving the efficiency of data retrieval for their Microsoft Dynamics 365 finance and operations apps. They have identified that the product table, which contains many records, is frequently accessed, and requires optimization.

You need to optimize data retrieval for the product table without modifying its existing structure.

What should you do? Each correct answer presents a complete solution. Choose two.

A Implement a caching strategy for the product table to improve read performance.
B Create an index on the product table for the most frequently queried fields.
C Create a summary table that aggregates frequently accessed data from the product table.
D A and B

Share this MCQ

Answer: D

Explanation:

Wrong:

Regularly defragment the product table’s reference tables.

Wrong:

Create a summary table that aggregates frequently accessed data from the product table.

Wrong:

Increase the database server's memory to enhance the product table’s performance.

Wrong:

Split the product table into multiple smaller tables based on product categories.

Implementing a caching strategy for the product table is an effective way to improve read performance, hence option A is correct. Creating an index on the product table for the most frequently queried fields can significantly enhance data retrieval times, making option C also correct. However, option B is incorrect as creating a summary table isn't optimizing the existing structure but rather creating a new one. Increasing the server's memory (option E) won't directly optimize data retrieval for a specific table. Splitting the table (option F) could potentially lead to data integrity issues and complicate the data model. Lastly, regular defragmentation (option D) is a general maintenance task and does not specifically optimize data retrieval for a particular table.

Add fields to tables through extension - Finance & Operations | Dynamics 365 | Microsoft Learn

Create tables and table fields - Training | Microsoft Learn

Exam MB-500: Microsoft Dynamics 365: Finance and Operations Apps Developer

Share Above MCQ

‹ Previous Next ›

Write your comment

Learn More MCQ Questions from Certification Exam Exam MB-500: Microsoft Dynamics 365: Finance and Operations Apps Developer

Report Question