CISA Exam Question 91
Which of the following is MOST important when implementing a data classification program?
Correct Answer: B
Data classification is the process of organizing data into categories based on its sensitivity, value, and risk to the organization. Data classification helps to ensure that data is protected according to its importance and regulatory requirements. Data classification also enables data owners to make informed decisions about data access, retention, and disposal.
To implement a data classification program, it is most important to formalize data ownership. Data owners are the individuals or business units that have the authority and responsibility for the data they create or use. Data owners should be involved in defining the data classification levels, assigning the appropriate classification to their data, and ensuring that the data is handled according to the established policies and procedures. Data owners should also review and update the data classification periodically or when there are changes in the data or its usage.
The other options are not as important as formalizing data ownership when implementing a data classification program. Understanding the data classification levels is necessary, but it is not sufficient without identifying the data owners who will apply them. Developing a privacy policy is a good practice, but it is not specific to data classification. Planning for secure storage capacity is a technical consideration, but it does not address the business and legal aspects of data classification.
References:
* ISACA, CISA Review Manual, 27th Edition, 2020, page 247
* Data Classification: What It Is and How to Implement It
To implement a data classification program, it is most important to formalize data ownership. Data owners are the individuals or business units that have the authority and responsibility for the data they create or use. Data owners should be involved in defining the data classification levels, assigning the appropriate classification to their data, and ensuring that the data is handled according to the established policies and procedures. Data owners should also review and update the data classification periodically or when there are changes in the data or its usage.
The other options are not as important as formalizing data ownership when implementing a data classification program. Understanding the data classification levels is necessary, but it is not sufficient without identifying the data owners who will apply them. Developing a privacy policy is a good practice, but it is not specific to data classification. Planning for secure storage capacity is a technical consideration, but it does not address the business and legal aspects of data classification.
References:
* ISACA, CISA Review Manual, 27th Edition, 2020, page 247
* Data Classification: What It Is and How to Implement It
CISA Exam Question 92
What is the BEST way to reduce the risk of inaccurate or misleading data proliferating through business intelligence systems?
Correct Answer: A
The best way to reduce the risk of inaccurate or misleading data proliferating through business intelligence systems is to establish rules for converting data from one format to another, because this ensures that the data quality and integrity are maintained throughout the data transformation process. Data conversion rules define the standards, procedures, and methods for transforming data from different sources and formats into a common format and structure that can be used by the business intelligence systems12. Implementing data entry controls for new and existing applications, implementing a consistent database indexing strategy, and developing a metadata repository to store and access metadata are not the best ways to reduce the risk of inaccurate or misleading data proliferating through business intelligence systems, because they do not address the issue of data conversion, which is a critical step in the data integration process for business intelligence systems. References: 1: CISA Review Manual (Digital Version), Chapter 4, Section 4.3.3 2: CISA Online Review Course, Module 4, Lesson 3
CISA Exam Question 93
The record-locking option of a database management system (DBMS) serves to.
Correct Answer: A
The record-locking option of a database management system (DBMS) serves to eliminate the risk of concurrent updates to a record by different users or transactions. Record locking is a technique of preventing simultaneous access to data in a database, to prevent inconsistent results1. For example, if two bank clerks try to update the same bank account for two different transactions, record locking can ensure that only one clerk can modify the record at a time, while the other has to wait until the lock is released. This way, the record will reflect both transactions correctly and avoid data corruption.
Record locking does not serve to allow database administrators (DBAs) to record the activities of users. This is a function of auditing or logging, which can track the actions performed by users on the database2. Record locking does not affect the ability of DBAs to monitor or audit user activities.
Record locking does not serve to restrict users from changing certain values within records. This is a function of access control or authorization, which can enforce rules or policies on what data users can view or modify2. Record locking does not affect the permissions or privileges of users on the database.
Record locking does not serve to allow users to lock others out of their files. This is a function of encryption or password protection, which can secure files from unauthorized access or modification3. Record locking does not affect the security or confidentiality of files on the database.
References:
Record locking - Wikipedia1
Database security - Wikipedia2
File system permissions - Wikipedia3
Record locking does not serve to allow database administrators (DBAs) to record the activities of users. This is a function of auditing or logging, which can track the actions performed by users on the database2. Record locking does not affect the ability of DBAs to monitor or audit user activities.
Record locking does not serve to restrict users from changing certain values within records. This is a function of access control or authorization, which can enforce rules or policies on what data users can view or modify2. Record locking does not affect the permissions or privileges of users on the database.
Record locking does not serve to allow users to lock others out of their files. This is a function of encryption or password protection, which can secure files from unauthorized access or modification3. Record locking does not affect the security or confidentiality of files on the database.
References:
Record locking - Wikipedia1
Database security - Wikipedia2
File system permissions - Wikipedia3
CISA Exam Question 94
Which of the following should be of GREATEST concern to an IS auditor reviewing system interfaces used to transfer publicly available information?
Correct Answer: D
Comprehensive and Detailed Step-by-Step Explanation:
Ensuring data integrity iscritical, even when handling publicly available information.
* Option A (Incorrect):While tracking system interfaces is useful formonitoring, it is not thegreatest concernif the data being transferred is publicly available.
* Option B (Incorrect):Encryption isimportant, but if the data is alreadypublic, therisk impact is lowercompared to data integrity issues.
* Option C (Incorrect):Data interception may not be a critical issue forpublicdata unless it leads to modification or exploitation.
* Option D (Correct):If thedata from the originating system differsfrom the downloaded data, it indicates adata integrity failure. This could result from system errors, transmission faults, or tampering, making it thehighest riskfor an IS auditor to address.
Reference:ISACA CISA Review Manual -Domain 4: Information Systems Operations and Business Resilience- Covers system interfaces, data integrity, and auditing techniques.
Ensuring data integrity iscritical, even when handling publicly available information.
* Option A (Incorrect):While tracking system interfaces is useful formonitoring, it is not thegreatest concernif the data being transferred is publicly available.
* Option B (Incorrect):Encryption isimportant, but if the data is alreadypublic, therisk impact is lowercompared to data integrity issues.
* Option C (Incorrect):Data interception may not be a critical issue forpublicdata unless it leads to modification or exploitation.
* Option D (Correct):If thedata from the originating system differsfrom the downloaded data, it indicates adata integrity failure. This could result from system errors, transmission faults, or tampering, making it thehighest riskfor an IS auditor to address.
Reference:ISACA CISA Review Manual -Domain 4: Information Systems Operations and Business Resilience- Covers system interfaces, data integrity, and auditing techniques.
CISA Exam Question 95
Which of the following is the MOST significant risk when an application uses individual end-user accounts to access the underlying database?
Correct Answer: C
The most significant risk when an application uses individual end-user accounts to access the underlying database is that users may be able to circumvent application controls. Application controls are the policies, procedures, and mechanisms that ensure the accuracy, completeness, validity, and authorization of transactions and data within an application. Application controls can include input validation, output verification, processing logic, reconciliation, exception handling, and audit trails. Application controls can help prevent or detect errors, fraud, or unauthorized access or modification of data.
However, if an application uses individual end-user accounts to access the underlying database, it means that the users have direct access to the database without going through the application layer. This can expose the database to potential risks such as:
* Users may be able to bypass the application controls and manipulate the data in the database directly using SQL commands or other tools. For example, users may be able to change their own or others' salaries, grades, or balances without proper authorization or validation.
* Users may be able to access or disclose sensitive or confidential data that they are not supposed to see or share. For example, users may be able to view other users' personal information, passwords, or credit card numbers.
* Users may be able to introduce errors or inconsistencies in the data by entering invalid or incorrect data or by deleting or modifying existing data. For example, users may be able to create duplicate records, break referential integrity, or cause data loss or corruption.
* Users may be able to compromise the security and performance of the database by creating unauthorized objects, granting excessive privileges, executing malicious code, or consuming excessive resources. For example, users may be able to create backdoors, viruses, or denial-of-service attacks.
Therefore, using individual end-user accounts to access the underlying database can pose a serious threat to the integrity, confidentiality, availability, and reliability of the data and the application.
The other options are not as significant as option C. Multiple connects to the database are used and slow the process is a performance issue that can affect the efficiency and responsiveness of the application and the database, but it does not necessarily compromise the data quality or security. User accounts may remain active after a termination is a security issue that can increase the risk of unauthorized access or misuse of data by former employees or others who have access to their credentials, but it can be mitigated by implementing proper account management and monitoring processes. Application may not capture a complete audit trail is a compliance issue that can affect the accountability and traceability of transactions and data within the application and the database, but it does not directly affect the data accuracy or protection.
References:
* Should application users be database users? - Stack Overflow1
* An Approach Toward Sarbanes-Oxley ITGC Risk Assessment - ISACA2
* ISACA CISA Certified Information Systems Auditor Exam ... - PUPUWEB3
* Why inactive accounts are a security risk | Stratosphere4
However, if an application uses individual end-user accounts to access the underlying database, it means that the users have direct access to the database without going through the application layer. This can expose the database to potential risks such as:
* Users may be able to bypass the application controls and manipulate the data in the database directly using SQL commands or other tools. For example, users may be able to change their own or others' salaries, grades, or balances without proper authorization or validation.
* Users may be able to access or disclose sensitive or confidential data that they are not supposed to see or share. For example, users may be able to view other users' personal information, passwords, or credit card numbers.
* Users may be able to introduce errors or inconsistencies in the data by entering invalid or incorrect data or by deleting or modifying existing data. For example, users may be able to create duplicate records, break referential integrity, or cause data loss or corruption.
* Users may be able to compromise the security and performance of the database by creating unauthorized objects, granting excessive privileges, executing malicious code, or consuming excessive resources. For example, users may be able to create backdoors, viruses, or denial-of-service attacks.
Therefore, using individual end-user accounts to access the underlying database can pose a serious threat to the integrity, confidentiality, availability, and reliability of the data and the application.
The other options are not as significant as option C. Multiple connects to the database are used and slow the process is a performance issue that can affect the efficiency and responsiveness of the application and the database, but it does not necessarily compromise the data quality or security. User accounts may remain active after a termination is a security issue that can increase the risk of unauthorized access or misuse of data by former employees or others who have access to their credentials, but it can be mitigated by implementing proper account management and monitoring processes. Application may not capture a complete audit trail is a compliance issue that can affect the accountability and traceability of transactions and data within the application and the database, but it does not directly affect the data accuracy or protection.
References:
* Should application users be database users? - Stack Overflow1
* An Approach Toward Sarbanes-Oxley ITGC Risk Assessment - ISACA2
* ISACA CISA Certified Information Systems Auditor Exam ... - PUPUWEB3
* Why inactive accounts are a security risk | Stratosphere4
- Other Version
- 2273ISACA.CISA.v2025-12-09.q630
- 14477ISACA.CISA.v2025-06-20.q647
- 5130ISACA.CISA.v2025-06-11.q606
- 3922ISACA.CISA.v2023-03-04.q272
- 3092ISACA.CISA.v2022-10-31.q203
- 3009ISACA.CISA.v2022-03-29.q126
- 123ISACA.Examprepaway.CISA.v2022-02-10.by.barret.126q.pdf
- 9647ISACA.CISA.v2021-11-29.q567
- 36ISACA.Actualvce.CISA.v2021-08-31.by.ralap.101q.pdf
- Latest Upload
- 112CBIC.CIC.v2026-06-15.q123
- 109Peoplecert.ITIL-4-Specialist-High-velocity-IT.v2026-06-15.q16
- 111HashiCorp.Terraform-Associate-004.v2026-06-15.q126
- 111Peoplecert.ITILFNDv5.v2026-06-15.q26
- 111Workday.Workday-Pro-HCM-Reporting.v2026-06-15.q28
- 111Fortinet.NSE5_SSE_AD-7.6.v2026-06-15.q17
- 114PMI.PMI-ACP.v2026-06-15.q523
- 111LinuxFoundation.CKAD.v2026-06-15.q118
- 155CrowdStrike.CCSE-204.v2026-06-12.q25
- 168VMware.2V0-17.25.v2026-06-12.q49
[×]
Download PDF File
Enter your email address to download ISACA.CISA.v2025-12-02.q704 Practice Test
