PracticeISCFree practice exam

ISC · Information Systems and Data Management · 6 practice questions

RPO vs. RTO: What Governs Database Replication?

When both replication modes are feasible, acceptable committed-data loss governs the choice, not allowable downtime. Sort one retailer’s facts: both modes are affordable and feasible, committed orders cannot be lost, and downtime cannot exceed 30 minutes.

The ruleWhen both replication designs are technically feasible and other requirements are satisfied, acceptable committed-data loss (RPO) governs whether asynchronous replication is sufficient; an outage allowance (RTO) does not permit additional data loss.

Try one first

HealthData Inc. is a multinational healthcare analytics provider that delivers near-real-time clinical decision support to hospitals in several countries. Some jurisdictions legally require patient data to be stored and processed within national borders and impose strict privacy/regulatory controls; regulators can effectively bar noncompliant vendors from operating. In one target country, cloud hosting is permitted only if data are kept in a certified in‑country region with local administrative controls. HealthData also needs low latency for alerts, wants to minimize capital expenditures, and plans to scale quickly into new markets. Which single factor should primarily govern HealthData's selection among on‑premises, public cloud, or hybrid infrastructure options?
Hint

Which requirement, if unmet, could legally prevent HealthData from operating in a country rather than merely affecting cost or performance?

Sort it

RPO: Data-loss requirement

Does this fact concern whether committed orders survive a failure?

RTO: Downtime requirement

Does this fact concern when customer service or processing must resume?

Feasibility already established

Does this fact make either design possible without deciding whether its data-loss protection is sufficient?

ItemGoes to
The database is the only source of committed order data that cannot be recreated.RPO: Data-loss requirementRebuilding other components cannot recover committed orders missing from the surviving database copy.
Order processing must resume within 30 minutes after the primary site fails.RTO: Downtime requirementThis deadline limits service interruption, not the number of committed orders that may disappear.
Management has approved enough budget for either synchronous or asynchronous replication.Feasibility already establishedBudget does not distinguish the options here. The selected design must still prevent committed-order loss.
Database failover and traffic routing must finish within the retailer’s 30-minute recovery window.RTO: Downtime requirementThese activities affect when users regain service. Completing them quickly does not establish that every committed order survived.
The retailer accepts no loss of committed orders when comparing feasible replication modes.RPO: Data-loss requirementA zero-data-loss RPO requires synchronous replication or an equivalent guarantee against loss of committed orders.
Network capacity and distance support either replication mode.Feasibility already establishedTechnical feasibility is already satisfied. It does not make asynchronous replication sufficient for the retailer’s zero-data-loss requirement.
Stateless application servers must be rebuilt and serving customers within the 30-minute outage allowance.RTO: Downtime requirementServer rebuilding affects restoration time. It does not replace committed orders missing from the database.
The alternate site already has enough compute capacity to run the application.Feasibility already establishedAdequate compute capacity does not establish that the standby database contains every committed order.
An asynchronous standby may be missing committed orders when the primary site fails.RPO: Data-loss requirementOrdinary asynchronous replication therefore does not guarantee this retailer’s zero-data-loss RPO.
The 30-minute outage allowance permits delayed service restoration, not 30 minutes of lost orders.RTO: Downtime requirementRTO measures unavailable service. The separate zero-data-loss RPO still governs replication.

Key points

  • Remember: permission to stop processing is not permission to lose orders.
  • Ask what the standby could be missing, not just how quickly it can start.
  • A feasible, affordable design still fails if it cannot meet the required RPO.

How the exam traps you

  • Treating the 30-minute outage allowance as an acceptable replication lag. The 30 minutes measures downtime, not permitted loss of committed orders.
  • Assuming quickly rebuilt application servers protect committed database transactions. Rebuilding stateless servers restores compute, not missing committed orders.
  • Choosing asynchronous replication because either design fits the budget. Affordability does not establish that asynchronous replication meets a zero-data-loss RPO.

5 more, each from a different angle

0 of 5 answered · 0 correct

Question 2

Metro Co. is replacing the storage used by its production-scheduling database. The database is small enough that either storage option has sufficient capacity, and both options can meet the same backup and security requirements. However, users report that slow disk response is delaying time-sensitive scheduling decisions. Which factor should primarily govern Metro's storage infrastructure decision?
Hint

Focus on the operational problem the users are experiencing, and set aside factors the stem says are already adequate under either option.

Question 3

An IT director is evaluating migrating several on-premises physical servers into a virtualized environment to improve overall server utilization and reduce hardware costs. Assume the enterprise hypervisor in use supports modern features (paravirtualized drivers, device passthrough, SR-IOV) and that vendor support for those configurations is assumed unless a scenario explicitly states otherwise. Which of the following scenarios is the best example of an exception or limiting condition where moving the workload to the virtualization platform is NOT likely to produce the expected utilization/cost benefits?
Hint

Determine which workload requires guaranteed, deterministic access to hardware (or has an explicit bare‑metal vendor restriction) rather than merely being performance‑sensitive or poorly configured.

Question 4

A retailer hosts its order-processing system in its own data center. Management states that, after a disruption, the system must be restored within 30 minutes and no more than a few minutes of transaction data can be lost. The company is comparing hot, warm, and cold disaster recovery sites. Which factor should primarily govern the infrastructure choice?
Hint

Focus on what separates hot, warm, and cold sites in practice: how fast they can restore operations and how much recent data they preserve.

Question 5

Falcon Bank is selecting the infrastructure for a new transaction-processing application. The application will store nonpublic customer financial data, must meet data-location and regulator-access requirements, and requires security configurations that Falcon's internal team wants to control directly. Management has stated that higher cost is acceptable if necessary to satisfy these needs. Assuming multiple infrastructure options are otherwise available, which factor should govern Falcon's decision?
Hint

Identify which stated requirement would be hardest for management to compromise, especially since the company is willing to pay more if necessary.

Question 6

RetailCo operates a regional retail chain whose on-premises ERP processes point-of-sale transactions, including payment card data subject to PCI-DSS. The ERP runs on eight-year-old servers in the corporate data center. The system is latency-sensitive and must remain highly available during peak periods to avoid lost sales. A public cloud provider proposes a multi-tenant hosted ERP, claims a 30% reduction in total cost of ownership, and states the platform is PCI-compliant. Security and compliance teams have not completed vendor due diligence or measured application performance in the cloud. The CFO asks you to recommend the best immediate action regarding the proposed migration. What should you do?
Hint

Prioritize validating compliance controls and measuring real-world application performance (vendor due diligence and a pilot) before approving a migration or long-term contract.

Drill all 157 IT infrastructure questionsMixed across every rule in the topic, so you have to spot which one applies. That is how the exam does it.

Common questions

Does RPO or RTO determine synchronous versus asynchronous replication?

When both designs are feasible and other requirements are satisfied, RPO governs whether asynchronous replication is sufficient. It measures acceptable loss of committed data.

Can a system allow 30 minutes of downtime but require zero data loss?

Yes. This retailer can stop processing for 30 minutes, but every committed order must survive. The outage allowance does not relax the data-loss requirement.

Can asynchronous replication guarantee a zero-data-loss RPO?

Ordinary asynchronous replication cannot guarantee it because the standby may lack committed orders at failure. This retailer needs synchronous replication or an equivalent guarantee against committed-data loss.

Practice ISC like the real exam

The free ChatCPA simulator: real exam layout, timed testlets, starting with a question on this topic. No account needed to start.

Open the free simulator →

More on IT infrastructure

All IT infrastructure practice →

Questions from the ChatCPA bank of 17,658 CPA exam questions, each with a written reason for every wrong answer. ChatCPA is built by Nicholas Miller, CPA (Oregon #14907). How these pages are made. Spot an error? Tell us.