Courseiva
← CISA
Full test
mediumMultiple ChoiceObjective-mapped

CISA Practice Question: A database administrator accidentally deleted a…

A database administrator accidentally deleted a critical table. The last full backup was taken 24 hours ago, and transaction logs are archived every 15 minutes. Which recovery method will minimize data loss?

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

✓

Restore from full backup and apply transaction logs up to the time of deletion

Restoring from the full backup and applying transaction logs up to the time of deletion (Option D) recovers all data except the very last transactions, minimizing data loss. Option A (standby database) does not help with accidental deletion unless point-in-time recovery is used. Option B (point-in-time recovery using transaction logs) requires a full backup as a base; alone it is insufficient. Option C (full backup only) loses 24 hours of data.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • ✗

    Use a standby database

    Why it's wrong here

    A standby may not have the exact state at deletion and requires configuration.

  • ✗

    Point-in-time recovery using transaction logs

    Why it's wrong here

    Requires a base backup to apply logs to.

  • ✗

    Restore from full backup only

    Why it's wrong here

    Loses all transactions after the full backup.

  • ✓

    Restore from full backup and apply transaction logs up to the time of deletion

    Why this is correct

    This recovery method recovers most data, limited only by the log archive interval.

About these practice questions

This CISA question is part of Courseiva's 995-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 →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This CISA practice question is part of Courseiva's free ISACA 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 CISA exam.