A business application’s database is copied to a replication server within minutes. Which of the following processes taking place during business hours will MOST benefit from this architecture?
A business application’s database is copied to a replication server within minutes. Which of the following processes taking place during business hours will MOST benefit from this architecture?
I think this is A. The question states during business hours and if a server goes down during business hours you need to transition to a backup or replication server to continue business functions.
The replication server can handle non-critical processes like reporting, analysis, or data extraction, reducing the load on the production server. Thus, ad hoc batch reporting jobs benefit the most from this replication setup.
The architecture’s greatest advantage during business hours lies in balancing transactional and analytical workloads. Ad hoc batch reporting jobs from the replication server (Option B) benefit most significantly, as they can be executed without disrupting the production database, leveraging the up-to-date replica to deliver timely insights. This aligns with daily business needs, ensuring both operational efficiency and analytical capability.