🔥 40% Off Crucial Exams Memberships — This Week Only

2 days, 9 hours remaining!
Crucial Exams

ISC2 Systems Security Certified Practitioner (SSCP) Practice Question

An e-commerce company runs its order processing database on a single high-end server in an on-premises data center. A recent disk controller failure took the site offline for four hours, violating the company's zero-downtime availability objective. Budget allows acquisition of one additional physical server but minimal software changes. Which control will most effectively meet the availability requirement?

  • Implement strict role-based access control to limit database administrator privileges.

  • Install a host-based intrusion detection system on the existing database server.

  • Deploy a two-node database cluster with synchronous replication and automatic failover between the primary and the new server.

  • Schedule differential database backups to an off-site tape library every six hours.

ISC2 Systems Security Certified Practitioner (SSCP)
Security Concepts and Practices
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot