Question 790A database administrator shares a privileged account, preventing investigators from attributing destructive schema changes. Which statement describes the central risk mechanism? Replication lag is a data quality and availability characteristic separate from connectivity. Row counts can match while entity relationships become corrupt. Backup completion does not establish recoverability or application integrity. Shared credentials remove accountability for database access and schema modifications. ExplanationCorrect Answer D:Shared credentials remove accountability for database access and schema modifications. The practical correction is to assign named privileged identities and audit protected administrative changes. Other Answers A:Replication lag is a data quality and availability characteristic separate from connectivity. The risk in this scenario follows a different principle: Shared credentials remove accountability for database access and schema modifications. B:Row counts can match while entity relationships become corrupt. The risk in this scenario follows a different principle: Shared credentials remove accountability for database access and schema modifications. C:Backup completion does not establish recoverability or application integrity. The risk in this scenario follows a different principle: Shared credentials remove accountability for database access and schema modifications.
Question 791A database administrator shares a privileged account, preventing investigators from attributing destructive schema changes. Which test best measures the control outcome in this scenario? Compare commit timestamps on primary and replica under business load. Trace a sample DDL operation to an individual authenticated identity. Restore a selected backup and reconcile representative business records. Run referential-integrity queries and compare exception counts to the source. ExplanationCorrect Answer B:Shared credentials remove accountability for database access and schema modifications. The selected test checks this actual control outcome rather than merely related configuration. Other Answers A:Replication lag is a data quality and availability characteristic separate from connectivity. This does not establish the required evidence: Trace a sample DDL operation to an individual authenticated identity. C:Backup completion does not establish recoverability or application integrity. This does not establish the required evidence: Trace a sample DDL operation to an individual authenticated identity. D:Row counts can match while entity relationships become corrupt. This does not establish the required evidence: Trace a sample DDL operation to an individual authenticated identity.
Question 792A database administrator shares a privileged account, preventing investigators from attributing destructive schema changes. Which ongoing control would MOST directly prevent recurrence? Include business rule and relationship validation in database migrations. Enforce freshness thresholds and consumer handling of stale replicas. Require named DBA access and privileged-session evidence retention. Schedule database recovery drills with evidence of results. ExplanationCorrect Answer C:Shared credentials remove accountability for database access and schema modifications. The safeguard makes this specific requirement part of ongoing governance rather than a one-time fix. Other Answers A:Row counts can match while entity relationships become corrupt. For this specific failure, the relevant preventive control is: Require named DBA access and privileged-session evidence retention. B:Replication lag is a data quality and availability characteristic separate from connectivity. For this specific failure, the relevant preventive control is: Require named DBA access and privileged-session evidence retention. D:Backup completion does not establish recoverability or application integrity. For this specific failure, the relevant preventive control is: Require named DBA access and privileged-session evidence retention.
Question 793A data warehouse migration lacks checks that foreign-key relationships remain valid after transformation. What is the MOST defensible control improvement for the stated problem? Validate referential integrity and reconciliation of critical data relationships. Enforce database access boundaries and validated transaction paths. Run isolated restore tests that verify database consistency and usable transactions. Assign named privileged identities and audit protected administrative changes. ExplanationCorrect Answer A:Row counts can match while entity relationships become corrupt. The confirming audit procedure is: Run referential-integrity queries and compare exception counts to the source. Other Answers B:Unrestricted direct data changes bypass application controls and may compromise integrity. For the stated failure, the appropriate corrective action is: Validate referential integrity and reconciliation of critical data relationships. C:Backup completion does not establish recoverability or application integrity. For the stated failure, the appropriate corrective action is: Validate referential integrity and reconciliation of critical data relationships. D:Shared credentials remove accountability for database access and schema modifications. For the stated failure, the appropriate corrective action is: Validate referential integrity and reconciliation of critical data relationships.
Question 794A data warehouse migration lacks checks that foreign-key relationships remain valid after transformation. Why is the present operating arrangement insufficient? Shared credentials remove accountability for database access and schema modifications. Row counts can match while entity relationships become corrupt. Replication lag is a data quality and availability characteristic separate from connectivity. Unrestricted direct data changes bypass application controls and may compromise integrity. ExplanationCorrect Answer B:Row counts can match while entity relationships become corrupt. The practical correction is to validate referential integrity and reconciliation of critical data relationships. Other Answers A:Shared credentials remove accountability for database access and schema modifications. The risk in this scenario follows a different principle: Row counts can match while entity relationships become corrupt. C:Replication lag is a data quality and availability characteristic separate from connectivity. The risk in this scenario follows a different principle: Row counts can match while entity relationships become corrupt. D:Unrestricted direct data changes bypass application controls and may compromise integrity. The risk in this scenario follows a different principle: Row counts can match while entity relationships become corrupt.
Question 795A data warehouse migration lacks checks that foreign-key relationships remain valid after transformation. Which audit check should establish whether the risk has been addressed? Run referential-integrity queries and compare exception counts to the source. Trace a sample DDL operation to an individual authenticated identity. Restore a selected backup and reconcile representative business records. Attempt an unauthorized direct update and inspect rejection and audit logs. ExplanationCorrect Answer A:Row counts can match while entity relationships become corrupt. The selected test checks this actual control outcome rather than merely related configuration. Other Answers B:Shared credentials remove accountability for database access and schema modifications. This does not establish the required evidence: Run referential-integrity queries and compare exception counts to the source. C:Backup completion does not establish recoverability or application integrity. This does not establish the required evidence: Run referential-integrity queries and compare exception counts to the source. D:Unrestricted direct data changes bypass application controls and may compromise integrity. This does not establish the required evidence: Run referential-integrity queries and compare exception counts to the source.
Question 796A data warehouse migration lacks checks that foreign-key relationships remain valid after transformation. Which future-control safeguard best preserves this correction? Use least privilege and approved stored procedures for sensitive data changes. Enforce freshness thresholds and consumer handling of stale replicas. Require named DBA access and privileged-session evidence retention. Include business rule and relationship validation in database migrations. ExplanationCorrect Answer D:Row counts can match while entity relationships become corrupt. The safeguard makes this specific requirement part of ongoing governance rather than a one-time fix. Other Answers A:Unrestricted direct data changes bypass application controls and may compromise integrity. For this specific failure, the relevant preventive control is: Include business rule and relationship validation in database migrations. B:Replication lag is a data quality and availability characteristic separate from connectivity. For this specific failure, the relevant preventive control is: Include business rule and relationship validation in database migrations. C:Shared credentials remove accountability for database access and schema modifications. For this specific failure, the relevant preventive control is: Include business rule and relationship validation in database migrations.
Question 797A disaster recovery plan treats every application equally even though the dispatch system must restart within an hour and the archive can wait a week. Which audit recommendation MOST directly addresses the particular gap? Perform business impact analysis to prioritize services by impact and recovery time. Include direct, indirect, legal and operational outage impacts in the BIA. Revalidate criticality and dependencies after the organizational change. Quantify business impacts and obtain owner agreement before fixing recovery priorities. ExplanationCorrect Answer A:BIA reveals acceptable disruption and helps allocate recovery resources proportionately. The confirming audit procedure is: Inspect approved service tiers with explicit RTOs and supporting dependency maps. Other Answers B:Business disruption cost extends beyond the price of failed equipment. For the stated failure, the appropriate corrective action is: Perform business impact analysis to prioritize services by impact and recovery time. C:Material changes can invalidate loss assumptions, recovery priorities and accountable owners. For the stated failure, the appropriate corrective action is: Perform business impact analysis to prioritize services by impact and recovery time. D:Recovery targets should reflect business consequence, not simply IT preference. For the stated failure, the appropriate corrective action is: Perform business impact analysis to prioritize services by impact and recovery time.
Question 798A disaster recovery plan treats every application equally even though the dispatch system must restart within an hour and the archive can wait a week. What principle best explains the auditor’s concern in this case? A critical application cannot resume if supporting identities and interfaces remain unavailable. Material changes can invalidate loss assumptions, recovery priorities and accountable owners. BIA reveals acceptable disruption and helps allocate recovery resources proportionately. Recovery targets should reflect business consequence, not simply IT preference. ExplanationCorrect Answer C:BIA reveals acceptable disruption and helps allocate recovery resources proportionately. The practical correction is to perform business impact analysis to prioritize services by impact and recovery time. Other Answers A:A critical application cannot resume if supporting identities and interfaces remain unavailable. The risk in this scenario follows a different principle: BIA reveals acceptable disruption and helps allocate recovery resources proportionately. B:Material changes can invalidate loss assumptions, recovery priorities and accountable owners. The risk in this scenario follows a different principle: BIA reveals acceptable disruption and helps allocate recovery resources proportionately. D:Recovery targets should reflect business consequence, not simply IT preference. The risk in this scenario follows a different principle: BIA reveals acceptable disruption and helps allocate recovery resources proportionately.
Question 799A disaster recovery plan treats every application equally even though the dispatch system must restart within an hour and the archive can wait a week. Which independently checked result is most relevant to the issue? Rehearse a recovery path including authentication and payment interfaces. Compare outage-loss scenarios and approved RTO with stakeholder signoff. Review BIA impact categories with compliance, customer service and finance. Inspect approved service tiers with explicit RTOs and supporting dependency maps. ExplanationCorrect Answer D:BIA reveals acceptable disruption and helps allocate recovery resources proportionately. The selected test checks this actual control outcome rather than merely related configuration. Other Answers A:A critical application cannot resume if supporting identities and interfaces remain unavailable. This does not establish the required evidence: Inspect approved service tiers with explicit RTOs and supporting dependency maps. B:Recovery targets should reflect business consequence, not simply IT preference. This does not establish the required evidence: Inspect approved service tiers with explicit RTOs and supporting dependency maps. C:Business disruption cost extends beyond the price of failed equipment. This does not establish the required evidence: Inspect approved service tiers with explicit RTOs and supporting dependency maps.
Question 800A disaster recovery plan treats every application equally even though the dispatch system must restart within an hour and the archive can wait a week. Which change-control rule best reduces repeat occurrences? Refresh BIA whenever critical business processes change. Maintain business-to-technology dependency maps as BIA inputs. Integrate finance and operations into periodic BIA reviews. Use standardized multidimensional impact criteria across critical services. ExplanationCorrect Answer A:BIA reveals acceptable disruption and helps allocate recovery resources proportionately. The safeguard makes this specific requirement part of ongoing governance rather than a one-time fix. Other Answers B:A critical application cannot resume if supporting identities and interfaces remain unavailable. For this specific failure, the relevant preventive control is: Refresh BIA whenever critical business processes change. C:Recovery targets should reflect business consequence, not simply IT preference. For this specific failure, the relevant preventive control is: Refresh BIA whenever critical business processes change. D:Business disruption cost extends beyond the price of failed equipment. For this specific failure, the relevant preventive control is: Refresh BIA whenever critical business processes change.