nerdexam
Isaca

CISA · Question #96

A database administrator (DBA) should be prevented from:

The correct answer is A. accessing sensitive information. A database administrator (DBA) should ideally be prevented from accessing sensitive information to uphold the principle of segregation of duties and prevent conflicts of interest.

Submitted by lars.no· Apr 18, 2026Protection of Information Assets

Question

A database administrator (DBA) should be prevented from:

Options

  • Aaccessing sensitive information.
  • Bhaving end user responsibilities.
  • Chaving access to production files.
  • Dusing an emergency user ID.

How the community answered

(23 responses)
  • A
    96% (22)
  • B
    4% (1)

Why each option

A database administrator (DBA) should ideally be prevented from accessing sensitive information to uphold the principle of segregation of duties and prevent conflicts of interest.

Aaccessing sensitive information.Correct

To maintain the principle of segregation of duties and minimize the risk of fraud or misuse, a DBA, who has powerful administrative privileges over the database structure and system, should ideally not also have the ability to view or manipulate sensitive data content unless strictly necessary and monitored. Their role is typically to manage the database *system*, not its *contents*.

Bhaving end user responsibilities.

Preventing a DBA from having end-user responsibilities is also part of segregation of duties, but the direct access to sensitive data (A) poses a more immediate and critical risk to data confidentiality and integrity.

Chaving access to production files.

DBAs inherently need access to production database files (or the database system that manages them) to perform their administrative duties such as backups, performance tuning, and integrity checks.

Dusing an emergency user ID.

An emergency user ID is a necessary control for all privileged roles, including DBAs, to ensure system access during critical outages when normal authentication methods fail.

Concept tested: Segregation of duties for DBAs

Source: https://learn.microsoft.com/en-us/azure/architecture/framework/security/design-identity-authentication#segregation-of-duties

Topics

#Segregation of Duties (SoD)#Access Control#Database Security#Least Privilege

Community Discussion

No community discussion yet for this question.

Full CISA Practice