mediumMultiple ChoiceObjective-mapped
FC0-U71 Practice Question: A database must be restored to the exact state at…
A database must be restored to the exact state at 11:00 AM. The last full backup was at 10:00 PM previous day, and transaction log backups were taken every hour. What is the minimum to restore?
⚠ Common exam trap
Watch out — candidates often think a differential backup can achieve point-in-time recovery, but differentials only capture changes up to a point, not the granular transaction-level detail needed to restore to an exact time like 11:00 AM.
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
✓
Full backup plus all transaction log backups from after full backup
To restore a database to a specific point in time (11:00 AM) when only full and transaction log backups exist, you must restore the most recent full backup (from 10:00 PM previous day) and then apply all subsequent transaction log backups in sequence. Transaction log backups contain all committed transactions up to the time of the backup, so applying them in order after the full backup brings the database to the exact state at the time of the last log backup (which would be 11:00 AM if the hourly log backup was taken at that time). Option A is correct because it includes the full backup and all transaction log backups taken after it, which is the minimum required for point-in-time recovery.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Full backup plus all transaction log backups from after full backup
Why this is correct
Enables restoration to any point in time.
- ✗
Transaction log backup only
Why it's wrong here
Requires full backup as base.
- ✗
Full backup only
Why it's wrong here
Does not include changes since backup.
- ✗
Full backup plus differential backup
Why it's wrong here
Differential may not capture all point-in-time.
Go deeper
Related to this question
About these practice questions
One of 988 original FC0-U71 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.