CPA Isc Quiz: Apply Data Analytics To Identify Anomalies

What this quiz covers

This quiz focuses on Apply Data Analytics To Identify Anomalies, giving you a quick way to practice the rules, question types, and explanations that matter most for CPA Isc.

How to use this quiz

Try each quiz question before looking at the correct answer. Use the explanations to review missed ideas, then come back to similar questions until the pattern feels familiar.

Question 1

1. To eliminate duplicate records from a data population before analysis.
2. To divide a data population into homogeneous subgroups based on defined characteristics so that each subgroup can be analyzed separately. (correct answer)
3. To calculate the statistical correlation between two variables in the dataset.
4. To convert unstructured data into a structured format suitable for analysis.

Explanation: Stratification divides data into meaningful subgroups (e.g., by dollar range, department, or transaction type) enabling focused analysis on high-risk segments. Answer B is correct. Deduplication (A) removes duplicates. Correlation (C) measures relationships between variables. Data conversion (D) is a data preparation technique.

Question 2

1. Matching and deduplication analysis comparing invoice number, vendor ID, amount, and date. (correct answer)
2. Regression analysis correlating invoice amounts to vendor size.
3. Time-series analysis of monthly payment totals.
4. Stratification of invoices by dollar amount range.

Explanation: Duplicate payment detection requires comparing records on key fields (invoice number, vendor, amount, date) to identify identical or near-identical entries. Matching and deduplication analysis directly addresses this. Answer A is correct. Regression (B), time-series (C), and stratification (D) do not identify duplicate individual transactions.

Question 3

1. Regression analysis to predict future payment trends.
2. Data normalization to prepare data for statistical analysis.
3. Anomaly detection to identify transactions that deviate from expected patterns. (correct answer)
4. Data visualization to present payment trends to management.

Explanation: Identifying payments that deviate from expected patterns (weekend timing, unknown vendors) is anomaly detection - a core data analytics technique used in auditing and fraud examination. Answer C is correct. Regression analysis (A) predicts relationships between variables. Data normalization (B) is a data preparation step. Visualization (D) presents findings but does not perform the detection.

Question 4

1. The expense data is accurate and normally distributed.
2. Employees may be fabricating or manipulating expense amounts, potentially clustering just below a review threshold. (correct answer)
3. The expense system contains data entry errors from incorrect date fields.
4. Employees are rounding expenses to the nearest dollar.

Explanation: Benford's Law predicts the natural frequency of leading digits in large numeric datasets. A spike in '5' as the leading digit often signals amounts clustered just below a common approval threshold (e.g., $500 or $5,000), a red flag for fraud. Answer B is correct. Accurate data (A) would conform to expected Benford's distribution. Date errors (C) would not create a leading-digit pattern in amounts. Rounding (D) affects trailing digits, not leading digits systematically.

Question 5

1. An audit conducted once per year using a complete population of transactions.
2. An approach in which auditors perform manual testing of controls on a sample basis.
3. An automated process that analyzes transactions on an ongoing basis and generates alerts when anomalies or exceptions are detected. (correct answer)
4. A method of preparing financial statements using real-time accounting data.

Explanation: Continuous auditing leverages automated analytics to monitor the full population of transactions on an ongoing basis, flagging exceptions for immediate investigation rather than waiting for periodic audits. Answer C is correct. Annual full-population testing (A) is traditional auditing. Manual sampling (B) is also traditional. Real-time financial reporting (D) is a financial reporting concept, not continuous auditing.

Question 6

1. Purchase order splitting - breaking a large purchase into smaller amounts to avoid authorization controls. (correct answer)
2. Vendor master file manipulation to add fictitious vendors.
3. Duplicate payments to legitimate vendors.
4. Unauthorized changes to inventory quantities in the ERP system.

Explanation: Flagging transactions just below approval thresholds detects 'splitting' - deliberately structuring purchases in amounts below authorization limits to circumvent controls. Answer A is correct. Vendor master manipulation (B) involves changes to vendor data. Duplicate payments (C) are detected by matching, not threshold analysis. Inventory quantity changes (D) are unrelated to purchase order amounts.

Question 7

1. Applying statistical models to predict future transaction patterns.
2. Visualizing data in charts to present findings to audit committees.
3. Examining the structure, content, and quality of a dataset to understand its characteristics and identify potential data issues before analysis. (correct answer)
4. Encrypting sensitive data fields before analysis to protect privacy.

Explanation: Data profiling involves understanding the dataset - its completeness, format consistency, range of values, null fields, and other characteristics - before running analytics, ensuring the analysis will produce reliable results. Answer C is correct. Predictive modeling (A) is a subsequent analytics step. Visualization (B) presents results. Encryption (D) is a data security measure.

Question 8

1. Regression analysis using journal entry amounts as the dependent variable.
2. Full population analysis with multiple filter criteria applied simultaneously to the complete journal entry file. (correct answer)
3. Statistical sampling of journal entries using systematic selection.
4. Cluster analysis to group journal entries by posting date.

Explanation: Testing the full population of journal entries against multiple risk-based criteria (round numbers, unusual dates, unusual preparers) simultaneously is the most comprehensive and appropriate approach. Answer B is correct. Regression (A) is predictive modeling. Statistical sampling (C) misses transactions not in the sample. Cluster analysis (D) groups similar items but does not apply specific risk filters.

Question 9

1. Trend analysis of total payroll costs over time.
2. Benford's Law analysis of payroll transaction amounts.
3. Exception reporting to identify transactions outside defined parameters. (correct answer)
4. Regression analysis to predict future payroll costs.

Explanation: Identifying transactions that fall outside defined acceptable ranges (approved increase percentage) is exception reporting - a fundamental anomaly detection technique. Answer C is correct. Trend analysis (A) looks at aggregate patterns over time. Benford's Law (B) analyzes leading digit distributions. Regression (D) models predictive relationships.

Question 10

1. Time-series analysis of payment amounts by vendor.
2. Stratification of vendors by payment frequency.
3. Cross-reference matching of vendor bank account numbers across all vendor master records. (correct answer)
4. Benford's Law analysis of vendor payment amounts.

Explanation: Cross-reference matching identifies shared attributes (same bank account) across different records - a key technique for detecting fictitious vendor schemes where one person controls multiple vendor accounts. Answer C is correct. Time-series (A), stratification (B), and Benford's Law (D) do not detect shared bank account numbers across vendor records.

Question 11

1. Completeness - ensuring all sales transactions are recorded.
2. Accuracy - identifying whether recorded revenue amounts are consistent with expectations based on underlying business activity. (correct answer)
3. Existence - confirming that recorded sales relate to actual transactions.
4. Cutoff - ensuring transactions are recorded in the correct period.

Explanation: Regression-based expectation models compare actual recorded amounts to analytically derived expectations, primarily testing whether revenue is accurately stated relative to underlying business drivers. Answer B is correct. Completeness (A) involves testing for missing transactions. Existence (C) involves confirming transactions occurred. Cutoff (D) involves timing of recognition.

Question 12

1. Ratio analysis to identify outliers relative to a benchmark. (correct answer)
2. Benford's Law analysis to examine leading digit frequencies.
3. Regression analysis to predict expected expense levels.
4. Stratification to group employees by expense category.

Explanation: Computing per-day expense ratios and comparing them to a benchmark identifies outliers using ratio analysis. Answer A is correct. Benford's Law (B) examines digit distributions, not computed ratios. Regression (C) models relationships between variables. Stratification (D) segments data into groups.

Question 13

1. Duplicate vendor payments processed during normal business hours.
2. Payroll fraud involving ghost employees.
3. Inventory theft by warehouse employees.
4. Unauthorized journal entries posted outside normal business hours by individuals attempting to conceal fraudulent activity. (correct answer)

Explanation: Fraudsters often post fictitious or concealing journal entries outside normal business hours to avoid detection. Flagging after-hours journal entries is a common automated control targeting this risk. Answer D is correct. Duplicate vendor payments (A) occur during business hours in normal processing. Ghost employees (B) are payroll-level anomalies. Inventory theft (C) is a physical control matter.

Question 14

1. Normal seasonal fluctuation in inventory levels.
2. Potential manipulation of period-end inventory to manage reported financial results. (correct answer)
3. Routine system recalibration performed by IT operations staff.
4. Data entry errors caused by inadequate training of warehouse staff.

Explanation: Systematic downward adjustments at quarter-end that reverse shortly after are a classic indicator of inventory manipulation to affect reported financial results (e.g., reducing COGS or asset values temporarily). Answer B is correct. Normal seasonal patterns (A) do not reverse immediately after quarter-end. IT recalibration (C) would not follow this financial reporting cycle pattern. Data entry errors (D) would be random, not systematic at quarter-end.

Question 15

1. Duplicate posting of the same invoice to multiple customers.
2. Unauthorized changes to customer credit limits.
3. Systematic rounding errors in the billing system.
4. Potentially fictitious or uncollectible balances that have not been written off or investigated. (correct answer)

Explanation: Receivable balances that remain static for extended periods often indicate write-off avoidance, fictitious receivables, or collection failures - anomalies that should trigger further investigation. Answer D is correct. Duplicate postings (A) would change rather than freeze balances. Credit limit changes (B) affect future credit, not static aging. Rounding errors (C) would create small discrepancies, not static large balances.

Question 16

1. Audit command language (ACL) / Galvanize or IDEA (Interactive Data Extraction and Analysis). (correct answer)
2. Python scripts for unstructured web data scraping.
3. Business intelligence dashboards for executive reporting.
4. Database normalization tools for schema design.

Explanation: ACL (now Galvanize) and IDEA are purpose-built audit data analytics tools designed to extract, manipulate, and analyze structured financial data from ERP and accounting systems. Answer A is correct. Python web scraping (B) targets unstructured external data. BI dashboards (C) are reporting tools, not audit analytics platforms. Database normalization tools (D) are for schema design, not analysis.

Question 17

1. Identify invoices with amounts that deviate from the average transaction value.
2. Detect duplicate invoice numbers that have been used more than once.
3. Identify missing invoice numbers that may indicate unrecorded sales transactions. (correct answer)
4. Calculate the statistical distribution of invoice amounts across customers.

Explanation: A gap analysis on pre-numbered documents identifies breaks in the numeric sequence, which may indicate missing or suppressed transactions - a key completeness test in auditing. Answer C is correct. Deviation from average amounts (A) is an exception test. Duplicate detection (B) is a separate test. Statistical distribution (D) is a different analytical procedure.

Question 18

1. Duplicate employee records in the HR system.
2. Unauthorized changes to the vendor master file.
3. Journal entries posted to incorrect general ledger accounts.
4. Payment of invoices that do not have a matching purchase order and goods receipt. (correct answer)

Explanation: A three-way match control compares the purchase order, goods receipt, and vendor invoice to ensure all three agree before payment is processed, preventing payment for goods not ordered or not received. Answer D is correct. Duplicate HR records (A) are unrelated. Vendor master changes (B) require access controls. GL coding errors (C) are addressed by coding controls, not three-way match.

Question 19

1. Data analytics always produces definitive evidence of fraud.
2. Data analytics eliminates the need for auditor judgment.
3. Data analytics is less expensive than traditional audit procedures.
4. Data analytics can test 100% of a transaction population, eliminating sampling risk. (correct answer)

Explanation: The primary advantage of data analytics over sampling is complete population testing - every transaction is examined, eliminating the risk of missing anomalies that fall outside a sample. Answer D is correct. Analytics does not prove fraud - it identifies exceptions requiring investigation (A). Auditor judgment remains essential (B). Analytics may require significant initial investment (C).

Question 20

1. Incomplete or inaccurate data in the source system, leading to false positives or missed anomalies. (correct answer)
2. The use of SQL queries rather than specialized audit software.
3. Analyzing data from multiple fiscal years rather than a single period.
4. The presence of large transaction amounts in the dataset.

Explanation: If source data is incomplete or inaccurate, analytics will produce unreliable results - either flagging legitimate transactions as anomalies or missing actual exceptions. Data quality is foundational to analytics reliability. Answer A is correct. SQL vs. specialized software (B) is a tool choice, not a data quality issue. Multi-year analysis (C) can be appropriate. Large amounts (D) are not inherently problematic.