Question 862 of 1,152
Security OperationshardMultiple ChoiceObjective-mapped

Quick Answer

The answer is to implement frequent transaction log backups and a pre-staged standby or automated recovery image. This combination directly improves both RTO and RPO for the ERP database by enabling point-in-time recovery to within minutes—slashing the RPO from 30 minutes to as low as 5–10 minutes—while the pre-staged standby eliminates the need for a full restore, cutting the RTO well below the two-hour target. On the Security+ SY0-701 exam, this scenario tests your understanding of disaster recovery controls under Domain 5 (Security Program Management and Oversight), specifically how backup frequency and recovery architecture trade off against each other. A common trap is choosing only faster backups (which improves RPO but not RTO) or only a standby server (which improves RTO but not RPO); the correct answer must address both metrics simultaneously. Remember the mnemonic “Logs for loss, standby for speed”—transaction logs shrink the recovery point, while a standby image shrinks the recovery time.

SY0-701 Security Operations Practice Question

This SY0-701 practice question tests your understanding of security operations. The scenario asks you to isolate a root cause — eliminate options that address a different problem before choosing. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.

Exhibit

System: ERP database cluster
Business requirements:
- RTO = 2 hours
- RPO = 30 minutes
Current recovery design:
- Nightly full backup at 23:00 to onsite NAS
- Differential backup at 12:00
- Weekly copy replicated to cloud on Sundays
Restore test results:
- Cold rebuild of VM + database restore: 5 hours 40 minutes
- Data gap since last backup: 2 hours 18 minutes
- NAS is online and joined to the same domain as production servers

Based on the exhibit, which change best improves both recovery time and recovery point for the ERP database?

A mid-sized company has a two-hour RTO and a 30-minute RPO, but its current backup design cannot meet either objective during restore testing.

Clue words in this question

Noticing these words before you look at the options changes how you read each choice.

  • Clue: "best"

    Why it matters: Signals that multiple options may be partially correct. Choose the option that most directly solves the exact problem described, not the one that sounds most complete.

Question 1hardmultiple choice
Full question →

Exhibit

System: ERP database cluster
Business requirements:
- RTO = 2 hours
- RPO = 30 minutes
Current recovery design:
- Nightly full backup at 23:00 to onsite NAS
- Differential backup at 12:00
- Weekly copy replicated to cloud on Sundays
Restore test results:
- Cold rebuild of VM + database restore: 5 hours 40 minutes
- Data gap since last backup: 2 hours 18 minutes
- NAS is online and joined to the same domain as production servers

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

Implement frequent transaction log backups and a pre-staged standby or automated recovery image.

Option C is correct because implementing frequent transaction log backups (e.g., every 5–10 minutes) allows point-in-time recovery, reducing the recovery point objective (RPO) to minutes. A pre-staged standby or automated recovery image reduces recovery time objective (RTO) by eliminating the need to restore from scratch, enabling near-instant failover. This directly addresses the company's inability to meet its 30-minute RPO and 2-hour RTO during restore testing.

Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Answer analysis

Option-by-option breakdown

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

  • Add a second nightly full backup at 23:30 to the same NAS device.

    Why it's wrong here

    A second full backup on the same storage does not materially improve restore speed or the data-loss window.

  • Move the NAS to a different VLAN but keep the backup schedule unchanged.

    Why it's wrong here

    Segmentation may reduce exposure, but it does not address the long restore duration or the poor RPO.

  • Implement frequent transaction log backups and a pre-staged standby or automated recovery image.

    Why this is correct

    Transaction log backups reduce the amount of data lost between full backups, improving the RPO. A pre-staged standby or automated recovery image shortens rebuild time, improving the RTO. Together, these changes directly address both recovery objectives instead of simply storing the same backups more safely or for longer. The test results show that the current restore approach is far too slow and too coarse.

    Clue confirmation

    The clue word "best" in the question point toward this answer.

    Related concept

    Read the scenario before looking for a memorised answer.

  • Increase backup retention from one month to one year.

    Why it's wrong here

    Longer retention helps compliance and historical recovery, but it does nothing to improve recovery speed or freshness.

Common exam traps

Common exam trap: answer the scenario, not the keyword

The trap here is that candidates confuse backup frequency (e.g., more full backups) with recovery point improvement, failing to recognize that only transaction log backups or incremental changes can reduce RPO below the full backup interval, and that pre-staging is required to meet aggressive RTOs.

Detailed technical explanation

How to think about this question

Transaction log backups capture every committed transaction since the last log backup, enabling granular point-in-time recovery (e.g., to 5 minutes before a failure). A pre-staged standby database, often maintained via log shipping or Always On availability groups, applies logs continuously so the standby is ready for immediate activation, reducing RTO to minutes. In contrast, restoring a full backup alone requires applying all subsequent differential and log backups sequentially, which can take hours for large databases.

KKey Concepts to Remember

  • Read the scenario before looking for a memorised answer.
  • Find the constraint that changes the correct option.
  • Eliminate answers that are true in general but not in this case.

TExam Day Tips

  • Watch for words such as best, first, most likely and least administrative effort.
  • Review why wrong options are wrong, not only why the correct option is correct.

Key takeaway

Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Real-world example

How this comes up in practice

A security analyst at a medium-sized enterprise encounters this scenario during an investigation or architecture review. The correct answer reflects best practice for the specific threat or control described. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Security exam questions test whether you can match controls to threats in context — not just recall definitions.

What to study next

Got this wrong? Here's your next step.

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

Related practice questions

Related SY0-701 practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

Practice this exam

Start a free SY0-701 practice session

Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.

FAQ

Questions learners often ask

What does this SY0-701 question test?

Security Operations — This question tests Security Operations — Read the scenario before looking for a memorised answer..

What is the correct answer to this question?

The correct answer is: Implement frequent transaction log backups and a pre-staged standby or automated recovery image. — Option C is correct because implementing frequent transaction log backups (e.g., every 5–10 minutes) allows point-in-time recovery, reducing the recovery point objective (RPO) to minutes. A pre-staged standby or automated recovery image reduces recovery time objective (RTO) by eliminating the need to restore from scratch, enabling near-instant failover. This directly addresses the company's inability to meet its 30-minute RPO and 2-hour RTO during restore testing.

What should I do if I get this SY0-701 question wrong?

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

Are there clue words in this question I should notice?

Yes — watch for: "best". Signals that multiple options may be partially correct. Choose the option that most directly solves the exact problem described, not the one that sounds most complete.

What is the key concept behind this question?

Read the scenario before looking for a memorised answer.

About these practice questions

Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Same concept, more angles

1 more ways this is tested on SY0-701

These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.

Variation 1. Based on the exhibit, which change best moves the ERP recovery design toward meeting both recovery targets?

hard
  • A.Increase the full backup frequency to every night and keep the same recovery process.
  • B.Add a warm standby database with 15-minute log shipping and scheduled failover tests.
  • C.Move backup media to the same server to reduce transfer time.
  • D.Eliminate differential backups and rely only on weekly full backups.

Why B: Option B is correct because adding a warm standby database with 15-minute log shipping significantly reduces the recovery point objective (RPO) to near-zero and, combined with scheduled failover tests, ensures the recovery time objective (RTO) is met. This directly addresses the gap between the current backup-only approach and the required recovery targets, as log shipping provides near-continuous data protection and failover testing validates the recovery process.

Keep practising

More SY0-701 practice questions

Last reviewed: Jun 11, 2026

Question Discussion

Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.

Loading comments…

Sign in to join the discussion.

This SY0-701 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 SY0-701 exam.