D561 Exam Questions with 100% Correct
Answers
AIS
Integrated system of people, procedures, data, software, IT infrastructure, and controls
General Ledger (GL)
Central summary of all accounts
Subsidiary Ledgers
Detailed records supporting GL (A/R, A/P, inventory)
Source Document
- Original document triggering a transaction
- Provides audit trail (sales order, invoice, receiving report)
Batch Processing
- Transactions accumulated and processed periodically
- Pros: Efficient
- Cons: Less timely
Real-Time Processing
- Transactions processed immediately
- Pros: Up-to-date data
- Cons: Higher system cost/complexity
DFD
Logical model showing data inputs, processing, storage, outputs
, Flowchart
Physical representation of system activities and controls
BPD/UML Activity Diagram
Visual map of activities with responsibility assignments
Which documentation tool best communicates who performs each task?
BPD/UML Activity Diagram
Which information quality characteristic is harmed by duplicate customer records?
Reliability, accuracy, completeness
Primary Key (PK)
- Unique, non-null identifier
- Can be natural or surrogate
Foreign Key (FK)
Enforces relationships between tables
Entity-Relationship Diagram (ERD)
Visual model of entities, attributes, relationships
Cardinality
Defines relationship rules:
- 1:1
- 1:M
- M:N
Schema
Answers
AIS
Integrated system of people, procedures, data, software, IT infrastructure, and controls
General Ledger (GL)
Central summary of all accounts
Subsidiary Ledgers
Detailed records supporting GL (A/R, A/P, inventory)
Source Document
- Original document triggering a transaction
- Provides audit trail (sales order, invoice, receiving report)
Batch Processing
- Transactions accumulated and processed periodically
- Pros: Efficient
- Cons: Less timely
Real-Time Processing
- Transactions processed immediately
- Pros: Up-to-date data
- Cons: Higher system cost/complexity
DFD
Logical model showing data inputs, processing, storage, outputs
, Flowchart
Physical representation of system activities and controls
BPD/UML Activity Diagram
Visual map of activities with responsibility assignments
Which documentation tool best communicates who performs each task?
BPD/UML Activity Diagram
Which information quality characteristic is harmed by duplicate customer records?
Reliability, accuracy, completeness
Primary Key (PK)
- Unique, non-null identifier
- Can be natural or surrogate
Foreign Key (FK)
Enforces relationships between tables
Entity-Relationship Diagram (ERD)
Visual model of entities, attributes, relationships
Cardinality
Defines relationship rules:
- 1:1
- 1:M
- M:N
Schema
