CPA Exam · Cheat Sheet
ISC — Information Systems & Controls (Discipline)
ISC — Information Systems & Controls (Discipline) | CHEAT SHEET
IT ARCHITECTURE & INFRASTRUCTURE
| Component | Definition |
|---|---|
| IaaS | Provider manages hardware/network; customer manages OS, runtime, apps (AWS EC2) |
| PaaS | Provider manages hardware/OS/runtime; customer manages apps, data (Salesforce) |
| SaaS | Provider manages everything; customer manages user data only (Microsoft 365) |
DATABASE & DATA GOVERNANCE
Key DB Concepts:
- Primary key = uniquely identifies each row
- Foreign key = enforces referential integrity between tables
- Normalization = reduces redundancy (1NF, 2NF, 3NF)
Governance Roles:
- Data steward = business owner; responsible for quality
- Data custodian = IT role; technical storage/maintenance
Data Quality Dimensions: Accuracy, Completeness, Consistency, Timeliness, Validity, Uniqueness
SYSTEMS DEVELOPMENT LIFE CYCLE (SDLC)
| Phase | Key Activity |
|---|---|
| Planning | Scope, feasibility, resources |
| Requirements | Gather functional & non-functional needs |
| Design | Architecture, database, security design |
| Development | Code per specifications |
| Testing | Unit → Integration → System → UAT |
| Implementation | Go-live, data conversion, training |
| Maintenance | Fixes, enhancements, monitoring |
Development Methodologies:
- Waterfall = Sequential; stable requirements
- Agile/Scrum = Iterative sprints; dynamic requirements
- DevOps = CI/CD; high-frequency releases
- Prototyping = Build early for feedback; unclear requirements
Change Management Controls: Formal request → Impact assessment → Test (non-prod) → Approval → Document
IT GENERAL CONTROLS (ITGC)
Four Pillars:
- Change management — formal process, testing, segregation of duties
- Logical access — provisioning, password policy, access reviews, termination
- Computer operations — backup, job scheduling, incident management
- Program development — SDLC, code review, version control
Segregation of Duties in IT:
- Developers ≠ production system access
- Operations ≠ source code access
- Users ≠ system admin access
APPLICATION CONTROLS
| Control Type | Examples |
|---|---|
| Input | Edit checks, validity checks, range checks, check digits, completeness, duplicates |
| Processing | Run-to-run totals, balancing, reasonableness checks |
| Output | Report distribution, reconciliation to inputs |
SECURITY FRAMEWORK (NIST CSF 2.0)
6 Functions (CSF 2.0 added Govern):
- Govern — strategy, roles, policy, oversight, supply-chain risk
- Identify — asset management, risk assessment
- Protect — access control, data security, training
- Detect — monitoring, anomaly detection
- Respond — incident response, mitigation
- Recover — recovery planning, improvements
Defense in Depth Layers: Physical → Network → Host → Application → Data
ACCESS CONTROL
Authentication Factors:
| Factor | Examples |
|---|---|
| Something you know | Password, PIN |
| Something you have | Token, smart card, OTP |
| Something you are | Biometrics (fingerprint, face, retina) |
MFA (Multi-Factor Auth) = 2+ factors; significantly stronger
Access Control Models:
- DAC = Resource owner sets permissions
- MAC = System enforces via labels (government/military)
- RBAC = Based on job role (most common)
- ABAC = Based on attributes (role + time + location)
Critical IAM Controls:
- Principle of least privilege = minimum access needed
- Segregation of duties = no single person: initiate + record + approve
- Access reviews = periodic verification (quarterly/annually)
- Termination procedures = IMMEDIATE revocation (highest risk control)
ENCRYPTION
| Type | Mechanism | Use Case |
|---|---|---|
| Symmetric | Same key encrypt/decrypt (AES) | Large data volumes; fast |
| Asymmetric | Public + private keys (PKI) | Key distribution, digital signatures |
| TLS/HTTPS | Asymmetric handshake → symmetric session | Secure web traffic |
Digital Signatures: Hash + sign with private key → verify with public key = authenticity + integrity
Encryption Locations:
- In transit = TLS/SSL, VPN, SSH
- At rest = disk encryption, database encryption
NETWORK SECURITY
| Control | Function |
|---|---|
| Firewall | Filters traffic by IP/port/protocol |
| IDS | Detects intrusions (passive alert) |
| IPS | Prevents intrusions (active block) |
| DMZ | Buffer zone between internet & internal network |
| Segmentation | Isolates critical assets; limits blast radius |
DATA ANALYTICS FOR AUDITORS
Continuous Monitoring = Management monitors controls in real-time (automated)
Continuous Auditing = Auditors perform procedures in real-time or near-real-time
Key Analytical Techniques:
- Benford's Law — detects fabricated numbers
- Regression analysis — identifies unexpected patterns
- Trend analysis — detects anomalies over time
- Outlier detection — finds values outside expected range
- Duplicate detection — identifies identical records
Data Sources for Testing: ERP transactions, journal entries (fraud), payroll, AP
DATA MIGRATION CONTROLS
✓ Field mapping (source → target) ✓ Parallel processing (both systems running) ✓ Reconcile before/after totals ✓ Retain pre-migration backups ✓ Full control total reconciliation
EXAM FOCUS:
Aligned to the standard reference materials.
Make this cheat sheet yours
Personalize this sheet — focus it however you study, or build one from the exact questions you keep getting wrong.