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. 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 2

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 3

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 4

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 5

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 6

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 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. 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 9

1. A genuine anomaly that was missed by the analytics procedure.
2. A transaction flagged as an anomaly by the analytics that, upon investigation, turns out to be a legitimate transaction. (correct answer)
3. An analytics procedure that produces incorrect calculations due to a programming error.
4. A data quality issue that corrupts the results of the analysis.

Explanation: A false positive occurs when the analytics flags a transaction that appears anomalous but is actually legitimate. Managing false positives is important to avoid wasting investigative resources. Answer B is correct. A missed genuine anomaly (A) is a false negative. Programming errors (C) are data analytics integrity issues. Data corruption (D) is a data quality issue.

Question 10

1. Apply professional judgment to prioritize the highest-risk exceptions and perform targeted investigation, documenting conclusions for each. (correct answer)
2. Immediately report all exceptions to law enforcement as potential fraud.
3. Dismiss all exceptions as false positives and rely on management's representations.
4. Expand the sample size to include more transactions in the analysis.

Explanation: When analytics produces many exceptions, the auditor applies professional judgment to prioritize those most likely to represent significant issues, investigates them, and documents the conclusions. Answer A is correct. Not all exceptions are fraud (B). Dismissing all exceptions (C) violates auditing standards. Expanding the sample (D) is irrelevant when full population analytics is already being used.

Question 11

1. A Benford's Law analysis of revenue transaction amounts.
2. A regression model predicting revenue based on headcount.
3. A comparison of active subscription counts from the CRM system to revenue recognition entries in the general ledger. (correct answer)
4. A stratification of revenue transactions by geographic region.

Explanation: Comparing active subscription records in the CRM to recognized revenue entries tests whether all active subscribers are generating revenue entries - a completeness test using cross-system analytics. Answer C is correct. Benford's Law (A) tests digit distributions, not completeness. Regression (B) develops an expectation but does not directly test completeness by subscription. Stratification (D) does not address completeness across systems.

Question 12

1. The process of visualizing audit findings in charts and graphs for the audit report.
2. The statistical process of selecting a representative sample from a large dataset.
3. The process of removing duplicate records from a dataset.
4. The process of retrieving and importing data from source systems into an analytics environment for analysis. (correct answer)

Explanation: Data extraction is the first step in the analytics process - pulling raw data from ERP, databases, or other source systems into the audit analytics environment. Answer D is correct. Visualization (A) is a later step in presenting results. Statistical sampling (B) is a different technique. Deduplication (C) is a data cleansing step that follows extraction.

Question 13

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 14

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 15

1. Data analytics cannot process more than a few thousand transactions at a time.
2. Data analytics results are not admissible as audit evidence.
3. Data analytics can only be applied to payroll data.
4. Data analytics identifies statistical exceptions that require professional judgment to determine whether they represent actual errors or fraud. (correct answer)

Explanation: Data analytics flags statistical anomalies, but every exception requires auditor judgment to determine whether it represents a genuine error, fraud, or an explainable legitimate transaction. Answer D is correct. Modern analytics tools handle millions of transactions (A). Analytics results are valid audit evidence (B). Analytics applies across all financial data, not just payroll (C).

Question 16

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 17

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 18

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 19

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.

Question 20

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.