Q:
You have been optimizing the performance of a Microsoft Dynamics 365 finance and operations apps. The app currently experiences slow load times due to inefficient data retrieval methods.
You need to implement a caching strategy that optimizes data retrieval for frequently accessed tables without significantly increasing the memory footprint.
What should you do?
-
A
Enable single-record caching for all tables regardless of their size to optimize data retrieval.
-
B
Set the CacheLookup property of frequently accessed small tables to EntireTable to enable set-based caching.
-
C
Disable all caching mechanisms to force direct database queries for real-time data access.
-
D
Increase the server cache size settings in System administration to accommodate caching of large tables.
B
Answer:
B
Explanation:
Option B is correct because set-based caching is suitable for small tables where the entire table can be cached efficiently. Option A is incorrect as single-record caching is not optimal for all tables, especially if they are not frequently accessed. Option D is incorrect because increasing the server cache size may not be efficient for large tables and could lead to disk-based searches which are slower. Option C is incorrect as disabling all caching would result in poor performance due to repeated database queries.
Identify and apply caching mechanisms - Training | Microsoft Learn
Related Topic:
Share Above MCQ