Describe the core capabilities of the finance and operations apps →hardMultiple ChoiceObjective-mapped
MB-920 Practice Question: Describe the core capabilities of the finance and operations apps
A company uses Dynamics 365 Finance and Operations. They are experiencing slow performance in the general ledger module when generating financial statements. The database administrator notices that the general journal table has grown significantly. Which action should they take to improve performance?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use the Data archiving feature to archive old journal entries.
The Data archiving feature in Dynamics 365 Finance and Operations allows moving old journal entries to a separate archive, reducing the table size and improving query performance without permanently deleting data. Option A is incorrect because partitioning the table may help but does not remove data; archiving is a better practice for reducing data volume. Option B is incorrect because adding indexes can improve read performance but also degrades write performance and does not address the root cause of large table size. Option C is incorrect because purging journal entries older than two years permanently deletes data that may be needed for reporting or legal purposes; archiving retains it.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Partition the general journal table by fiscal year.
Why it's wrong here
Partitioning the table may help with data organization but does not reduce data volume; archiving is a better practice.
- ✗
Add additional indexes to the general journal table.
Why it's wrong here
Adding indexes can improve query performance but does not reduce table size and may degrade write performance.
- ✗
Purge all journal entries older than two years.
Why it's wrong here
Purging journal entries permanently deletes data that might be needed; archiving is preferred to retain data while improving performance.
- ✓
Use the Data archiving feature to archive old journal entries.
Why this is correct
The Data archiving feature moves old entries to a separate archive, reducing table size and improving query performance without data loss.
Go deeper
Related to this question
About these practice questions
This MB-920 question is part of Courseiva's 930-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This MB-920 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the MB-920 exam.