Isaca CISA Quiz 205 Topic 1 Questions 1021-1025

Question: 1

When performing a database review, an IS auditor notices that some tables in the database are not normalized. The IS auditor should next:

Arecommend that the database be normalized.

Breview the conceptual data model.

Creview the stored procedures.

Dreview the justification.

Show Answer

Question: 2

A database administrator has detected a performance problem with some tables which could be solved through denormalization. This situation will increase the risk of:

Aconcurrent access.

Bdeadlocks.

Cunauthorized access to data.

Da loss of data integrity.

Show Answer

Question: 3

An IS auditor finds that client requests were processed multiple times when received

from different independent departmental databases, which are synchronized weekly. What would be the BEST recommendation?

Aincrease the frequency for data replication between the different department systems to ensure timely updates.

BCentralize all request processing in one department to avoid parallel processing of the same request.

CChange the application architecture so that common data are held in just one shared database for all departments.

Dimplement reconciliation controls to detect duplicates before orders are processed in the systems.

Show Answer

Question: 4

Which of the following database controls would ensure that the integrity of transactions is maintained in an online transaction processing system's database?

AAuthentication controls

BData normalization controls

CRead/write access log controls

DCommitment and rollback controls

Show Answer

Question: 5

An IS auditor finds that, at certain times of the day, the data warehouse query performance decreases significantly. Which of the following controls would it be relevant for the IS auditor to review?

APermanent table-space allocation

BCommitment and rollback controls

CUser spool and database limit controls

DRead/write access log controls

Show Answer

Isaca CISA Quiz:205 Topic:1 Questions:1021-1025