hardMultiple ChoiceObjective-mapped
FC0-U71 Practice Question: A small business runs a legacy inventory…
A small business runs a legacy inventory management application that was developed in-house. The application uses a local database stored on a single server running Windows Server 2016. Recently, the application has become slow during peak hours, and multiple users have reported timeouts. The server has 8GB of RAM and a quad-core processor. The application's database grows by about 500MB per month. The company's IT budget is limited, and they cannot rewrite the application. As an IT consultant, which recommendation would best improve performance without requiring application changes?
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
✓
Schedule database archiving to reduce the active data size
Scheduling database archiving reduces the active data size, directly addressing the performance degradation caused by database growth without requiring any changes to the application. Option A is incorrect because adding RAM does not reduce the data volume and may only provide marginal benefit if the bottleneck is I/O or data size. Option C is incorrect because migrating to a cloud-based SQL service could improve scalability but often involves application modifications and higher costs, which the business cannot afford. Option D is incorrect because implementing database indexing and query optimization typically requires changes to the application or database schema, which is not feasible since the application cannot be rewritten.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Increase the server's RAM to 32GB
Why it's wrong here
More RAM may improve caching but does not address database growth.
- ✓
Schedule database archiving to reduce the active data size
Why this is correct
Archiving old data reduces the working set, improving performance without altering the application.
- ✗
Migrate the database to a cloud-based SQL service
Why it's wrong here
Cloud migration is expensive and may require application modifications.
- ✗
Implement database indexing and query optimization
Why it's wrong here
Indexing requires changes to the database schema or queries, which may be considered application changes.
Go deeper
Related to this question
About these practice questions
Courseiva writes every FC0-U71 question from scratch — 988 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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 FC0-U71 practice question is part of Courseiva's free CompTIA 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 FC0-U71 exam.