ISC CISSP Practice Test 78
Question 770
A database security change passes staging but operations cannot show how to roll back if production queries fail. What should the security manager recommend as the MOST appropriate response to the current requirement?
- Deploy immediately and improvise rollback only after a major outage.
- Test versioned redeployment and data migration rollback handling.
- Use documented emergency change approval, scoped testing, rollback plan and retrospective review.
- Prepare tested backout procedures, dependency checks and rollback decision thresholds before deployment.
Explanation
Correct Answer
D:A change plan must address availability and data consistency if assumptions prove wrong. This directly addresses the stated situation.
Incorrect Answers
A:Unprepared rollback can amplify failure and corrupt state. The proposal would not be defensible for this case.
B:This is appropriate for a later condition (The system moves to immutable deployment artifacts rather than in-place changes.), but it does not directly resolve the initial need. Immutable infrastructure changes recovery mechanics but does not remove rollback duty.
C:This response addresses a different condition: A firewall engineer must deploy an urgent ACL change to restore a failing emergency service. The present case requires the measure described by Prepare tested backout procedures, dependency checks and rollback decision thresholds before deployment.
Question 771
A database security change passes staging but operations cannot show how to roll back if production queries fail. A designer proposes: Deploy immediately and improvise rollback only after a major outage. What is the MOST significant security deficiency in this proposal?
- Indefinite broad access creates unjustified exposure and no audit trail.
- Immutable infrastructure changes recovery mechanics but does not remove rollback duty.
- Emergency speed should not bypass accountability or safety checks entirely.
- Unprepared rollback can amplify failure and corrupt state.
Explanation
Correct Answer
D:Unprepared rollback can amplify failure and corrupt state. This is the direct weakness in the proposed action.
Incorrect Answers
A:This is a limitation elsewhere: A firewall engineer must deploy an urgent ACL change to restore a failing emergency service. It does not explain the deficiency of the specified proposed approach.
B:This explains a later shift in requirements (The system moves to immutable deployment artifacts rather than in-place changes.), not the failure of the current proposal.
C:This is an advantage of another design (Use documented emergency change approval, scoped testing, rollback plan and retrospective review.), not the particular flaw of Deploy immediately and improvise rollback only after a major outage.
Question 772
A database security change passes staging but operations cannot show how to roll back if production queries fail. The organization has now implemented this response: Prepare tested backout procedures, dependency checks and rollback decision thresholds before deployment. Which observation would MOST directly demonstrate that the security objective was met?
- Change records and traffic tests confirm the required service with no forbidden paths.
- Automated drift reconciliation identifies manual changes and verifies corrected production controls.
- An approved change ticket for Prepare tested backout procedures, dependency checks and rollback decision thresholds before deployment. without a completed verification result.
- A controlled test restores the previous working configuration without loss.
Explanation
Correct Answer
D:A controlled test restores the previous working configuration without loss. This validates that a change plan must address availability and data consistency if assumptions prove wrong.
Incorrect Answers
A:This demonstrates controls in another circumstance: A firewall engineer must deploy an urgent ACL change to restore a failing emergency service.
B:This other observation is relevant to: A cloud environment uses infrastructure-as-code but local engineers modify production resources directly through a console.
C:An approved change without an executed test cannot prove operating effectiveness. The needed evidence is A controlled test restores the previous working configuration without loss.
Question 773
An enterprise backs up files nightly but stores writable backup copies under the same administrative identities as production. What should the security manager recommend as the MOST appropriate response to the current requirement?
- Depend solely on a daily snapshot that compromised administrators can delete.
- Add appropriately frequent replication or log shipping with data-consistency checks.
- Design alternate production and recovery capability based on business impact analysis.
- Use isolated immutable backups with independent access and validated restores.
Explanation
Correct Answer
D:Ransomware that controls production administrators may otherwise destroy recovery copies. This directly addresses the stated situation.
Incorrect Answers
A:Writable snapshots under the same trust boundary do not provide resilient recovery. The proposal would not be defensible for this case.
B:This is appropriate for a later condition (Business objectives require only minutes of acceptable data loss for a transaction database.), but it does not directly resolve the initial need. A tight RPO may need continuous data protection beyond daily immutable copies.
C:This response addresses a different condition: A manufacturer runs one production line from a facility vulnerable to seasonal flooding. The present case requires the measure described by Use isolated immutable backups with independent access and validated restores.
Question 774
An enterprise backs up files nightly but stores writable backup copies under the same administrative identities as production. A designer proposes: Depend solely on a daily snapshot that compromised administrators can delete. What is the MOST significant security deficiency in this proposal?
- Uncontrolled divergent state can cause irreversible business errors.
- A tight RPO may need continuous data protection beyond daily immutable copies.
- Availability design must address split-brain and data correctness under partition.
- Writable snapshots under the same trust boundary do not provide resilient recovery.
Explanation
Correct Answer
D:Writable snapshots under the same trust boundary do not provide resilient recovery. This is the direct weakness in the proposed action.
Incorrect Answers
A:This is a limitation elsewhere: A customer-facing service has active-active database replicas but inconsistent writes during network partition tests. It does not explain the deficiency of the specified proposed approach.
B:This explains a later shift in requirements (Business objectives require only minutes of acceptable data loss for a transaction database.), not the failure of the current proposal.
C:This is an advantage of another design (Define consistency, quorum and failover policy suitable for transaction integrity and availability targets.), not the particular flaw of Depend solely on a daily snapshot that compromised administrators can delete.
Question 775
An enterprise backs up files nightly but stores writable backup copies under the same administrative identities as production. The organization has now implemented this response: Use isolated immutable backups with independent access and validated restores. Which observation would MOST directly demonstrate that the security objective was met?
- Site failure exercise demonstrates prioritized production recovery at the alternate site.
- Partition simulations preserve agreed write safety and quantified recovery objectives.
- An approved change ticket for Use isolated immutable backups with independent access and validated restores. without a completed verification result.
- A controlled compromised-admin test cannot modify the protected backup and restore succeeds.
Explanation
Correct Answer
D:A controlled compromised-admin test cannot modify the protected backup and restore succeeds. This validates that ransomware that controls production administrators may otherwise destroy recovery copies.
Incorrect Answers
A:This demonstrates controls in another circumstance: A manufacturer runs one production line from a facility vulnerable to seasonal flooding.
B:This other observation is relevant to: A customer-facing service has active-active database replicas but inconsistent writes during network partition tests. In the current case, the assessed requirement is: An enterprise backs up files nightly but stores writable backup copies under the same administrative identities as production. The organization has now implemented this response: Use isolated immutable backups with independent access and validated restores. Which observation would MOST directly demonstrate that the security objective was met.
C:An approved change without an executed test cannot prove operating effectiveness. The needed evidence is A controlled compromised-admin test cannot modify the protected backup and restore succeeds.
Question 776
A previous security situation was: An enterprise backs up files nightly but stores writable backup copies under the same administrative identities as production. Now the requirement changes: Business objectives require only minutes of acceptable data loss for a transaction database. Which NEW action BEST answers the changed need?
- Use isolated immutable backups with independent access and validated restores.
- Depend solely on a daily snapshot that compromised administrators can delete.
- A controlled compromised-admin test cannot modify the protected backup and restore succeeds.
- Add appropriately frequent replication or log shipping with data-consistency checks.
Explanation
Correct Answer
D:A tight RPO may need continuous data protection beyond daily immutable copies. The revised action is Add appropriately frequent replication or log shipping with data-consistency checks.
Incorrect Answers
A:This is the appropriate response to the original situation: Ransomware that controls production administrators may otherwise destroy recovery copies. It does not directly meet the new condition.
B:This remains inappropriate: Writable snapshots under the same trust boundary do not provide resilient recovery.
C:This is a record of how the initial safeguard would be checked, not an action implementing the newly requested condition: A controlled compromised-admin test cannot modify the protected backup and restore succeeds.
Question 777
A manufacturer runs one production line from a facility vulnerable to seasonal flooding. What should the security manager recommend as the MOST appropriate response to the current requirement?
- Reduce common-mode dependency with independent energy and supplier arrangements.
- Define consistency, quorum and failover policy suitable for transaction integrity and availability targets.
- Design alternate production and recovery capability based on business impact analysis.
- Add a second machine in the same flood zone and claim geographic redundancy.
Explanation
Correct Answer
C:Business continuity must mitigate location-specific physical failure modes. This directly addresses the stated situation.
Incorrect Answers
A:This is appropriate for a later condition (The alternate site itself depends on the same single power utility.), but it does not directly resolve the initial need. Redundancy must remove shared failure domains, not merely duplicate assets.
B:This response addresses a different condition: A customer-facing service has active-active database replicas but inconsistent writes during network partition tests. The present case requires the measure described by Design alternate production and recovery capability based on business impact analysis.
D:Co-located redundant hardware still shares the flood risk. The proposal would not be defensible for this case.
Question 778
A manufacturer runs one production line from a facility vulnerable to seasonal flooding. A designer proposes: Add a second machine in the same flood zone and claim geographic redundancy. What is the MOST significant security deficiency in this proposal?
- Redundancy must remove shared failure domains, not merely duplicate assets.
- Ransomware that controls production administrators may otherwise destroy recovery copies.
- Co-located redundant hardware still shares the flood risk.
- Writable snapshots under the same trust boundary do not provide resilient recovery.
Explanation
Correct Answer
C:Co-located redundant hardware still shares the flood risk. This is the direct weakness in the proposed action.
Incorrect Answers
A:This explains a later shift in requirements (The alternate site itself depends on the same single power utility.), not the failure of the current proposal.
B:This is an advantage of another design (Use isolated immutable backups with independent access and validated restores.), not the particular flaw of Add a second machine in the same flood zone and claim geographic redundancy.
D:This is a limitation elsewhere: An enterprise backs up files nightly but stores writable backup copies under the same administrative identities as production. It does not explain the deficiency of the specified proposed approach.
Question 779
A manufacturer runs one production line from a facility vulnerable to seasonal flooding. The organization has now implemented this response: Design alternate production and recovery capability based on business impact analysis. Which observation would MOST directly demonstrate that the security objective was met?
- A controlled compromised-admin test cannot modify the protected backup and restore succeeds.
- An approved change ticket for Design alternate production and recovery capability based on business impact analysis. without a completed verification result.
- Site failure exercise demonstrates prioritized production recovery at the alternate site.
- Partition simulations preserve agreed write safety and quantified recovery objectives.
Explanation
Correct Answer
C:Site failure exercise demonstrates prioritized production recovery at the alternate site. This validates that business continuity must mitigate location-specific physical failure modes.
Incorrect Answers
A:This other observation is relevant to: An enterprise backs up files nightly but stores writable backup copies under the same administrative identities as production. In the current case, the assessed requirement is: A manufacturer runs one production line from a facility vulnerable to seasonal flooding. The organization has now implemented this response: Design alternate production and recovery capability based on business impact analysis. Which observation would MOST directly demonstrate that the security objective was met.
B:An approved change without an executed test cannot prove operating effectiveness. The needed evidence is Site failure exercise demonstrates prioritized production recovery at the alternate site.
D:This demonstrates controls in another circumstance: A customer-facing service has active-active database replicas but inconsistent writes during network partition tests.
Question 780
A previous security situation was: A manufacturer runs one production line from a facility vulnerable to seasonal flooding. Now the requirement changes: The alternate site itself depends on the same single power utility. Which NEW action BEST answers the changed need?
- Add a second machine in the same flood zone and claim geographic redundancy.
- Site failure exercise demonstrates prioritized production recovery at the alternate site.
- Reduce common-mode dependency with independent energy and supplier arrangements.
- Design alternate production and recovery capability based on business impact analysis.
Explanation
Correct Answer
C:Redundancy must remove shared failure domains, not merely duplicate assets. The revised action is Reduce common-mode dependency with independent energy and supplier arrangements.
Incorrect Answers
A:This remains inappropriate: Co-located redundant hardware still shares the flood risk.
B:This is a record of how the initial safeguard would be checked, not an action implementing the newly requested condition: Site failure exercise demonstrates prioritized production recovery at the alternate site.
D:This is the appropriate response to the original situation: Business continuity must mitigate location-specific physical failure modes. It does not directly meet the new condition.