A company transfers daily sales data from its point-of-sale system to its general ledger. Which of the following controls would best detect if records were lost during the transfer?
Opening subject page...
Loading your content
CPA Isc Quiz
Practice Assess Interface And Data Transfer Controls in CPA Isc with focused quiz questions that help you check what you know, review explanations, and build confidence with test-style prompts.
Question 1 / 20
0 of 20 answered
A company transfers daily sales data from its point-of-sale system to its general ledger. Which of the following controls would best detect if records were lost during the transfer?
This quiz focuses on Assess Interface And Data Transfer Controls, giving you a quick way to practice the rules, question types, and explanations that matter most for CPA Isc.
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.
A company transfers daily sales data from its point-of-sale system to its general ledger. Which of the following controls would best detect if records were lost during the transfer?
Explanation: Record count and control total reconciliation between source and target systems directly detects data loss during transfer. Answer B is correct. Supervisor review (A) is a manual authorization control. Encryption (C) protects confidentiality. Access restrictions (D) address authorization, not completeness.
An automated interface between a payroll system and a bank's ACH payment system fails silently - transactions are dropped without generating an error alert. Which type of control is most notably absent?
Explanation: Silent failures indicate the absence of error handling and notification controls - the interface should detect failures and alert responsible staff immediately so corrective action can be taken. Answer C is correct. Encryption (A), access controls (B), and digital signatures (D) do not address the silent failure detection gap.
A company's procurement system automatically sends approved purchase orders to a supplier portal. Which of the following is the most critical interface control to implement?
Explanation: The most critical interface control ensures that only properly authorized transactions are transmitted - preventing unapproved orders from reaching suppliers and avoiding unauthorized commitments. Answer A is correct. TLS (B) addresses transit security. Supplier confirmation (C) is a business process control. Historical view restrictions (D) address access, not authorization.
A company uses an API to receive customer order data from an e-commerce platform and load it into its ERP system. Which of the following interface controls is most important to verify the authenticity of data received through this API?
Explanation: API authentication controls verify that data is received from a legitimate, authorized source, preventing malicious or unauthorized parties from injecting data into the ERP system. Answer D is correct. Compression (A) is a performance measure. Staging tables (B) aid processing but don't verify authenticity. Weekly reconciliation (C) is detective, not preventive.
Which of the following is the primary risk associated with using flat file interfaces (such as CSV files) for transferring financial data between systems?
Explanation: Unlike direct system-to-system APIs, flat files are discrete files that can be intercepted and manually altered before processing, creating a risk of unauthorized modification. Answer C is correct. Flat files are widely compatible (A) and can contain millions of records (B). Flat files can be encrypted (D).
A company's payroll interface generates a hash value of the payroll file before transmission and verifies the hash upon receipt. The purpose of this control is to:
Explanation: Hash verification detects changes to file content - if the hash upon receipt differs from the hash at transmission, the file was altered or corrupted during transit. Answer B is correct. Encryption (A) protects confidentiality. Hash verification detects changes but does not authenticate the sender (C). Compression (D) is unrelated to hashing.
Which of the following best describes the purpose of a 'staging area' or 'landing zone' in a system interface architecture?
Explanation: A staging area holds incoming data for validation, transformation, and cleansing before it enters the production target system, serving as a quality gate between source and destination. Answer B is correct. Key storage (A) is a key management function. Backup systems (C) serve disaster recovery. Monitoring consoles (D) are operational tools.
Which of the following is a key characteristic that distinguishes real-time (API-based) interfaces from batch interfaces from a controls perspective?
Explanation: Real-time interfaces require per-transaction validation since there is no batch aggregation. Batch interfaces enable pre/post run control total comparisons across the group. Both have distinct control requirements. Answer A is correct. Real-time interfaces can be highly secure (B). Batch interfaces require reconciliation (C). Real-time interfaces absolutely require error handling (D).
An IT auditor is assessing the controls over a financial data interface and requests interface run logs for the past quarter. What information in these logs is most relevant to the audit?
Explanation: Interface run logs document execution history - when the interface ran, how many records were processed, and any errors or failures. This information is essential for assessing completeness, reliability, and incident response. Answer C is correct. Developer names (A) and server specs (B) are not relevant to interface control testing. Source code review (D) is a separate IT audit procedure.
A company's interface transmits accounts payable data from a subsidiary to the parent company's consolidation system. An auditor verifies that the total accounts payable balance in the subsidiary's system equals the amount received by the parent's consolidation system. This audit procedure tests which assertion?
Explanation: Comparing source to target totals tests completeness of the data transfer - ensuring all data moved across the interface without loss. Answer B is correct. Existence (A) tests whether recorded items are real. Valuation (C) tests measurement. Rights and obligations (D) tests legal standing.
A company implements automated three-way match in its procure-to-pay interface, comparing purchase orders, goods receipts, and vendor invoices before authorizing payment. From an interface controls perspective, this primarily addresses which risk?
Explanation: Three-way match ensures that payments are only authorized when the invoice matches an approved purchase order and a confirmed receipt - preventing payment of unauthorized, duplicate, or inflated invoices. Answer A is correct. Encryption (B), latency (C), and vendor master access (D) are separate control concerns.
A company's interface between its CRM and billing systems incorrectly maps the 'discount percentage' field, resulting in customers being overcharged. This type of error is best detected by which control?
Explanation: End-to-end testing with scenarios covering discounts would reveal mapping errors before go-live by comparing expected to actual output - detecting logic errors in the interface. Answer A is correct. Encryption (B) does not detect logical mapping errors. Access restriction (C) limits who can make changes but does not detect errors. Change logging (D) tracks changes but does not verify correctness.
Which of the following is a preventive interface control designed to stop unauthorized or erroneous data from entering a target system?
Explanation: Input validation rules in the interface layer are preventive - they stop invalid records from entering the target system before any processing occurs. Answer C is correct. Error log review (A), record count comparisons (B), and exception reports (D) are all detective controls that identify problems after they have occurred.
A financial institution uses SWIFT messaging to transfer funds between banks. Which of the following controls is most critical for ensuring the integrity of SWIFT messages?
Explanation: Digital signatures and MACs verify the authenticity and integrity of financial messages, preventing tampering or fabrication in transit - essential for high-value financial transactions. Answer B is correct. Archiving (A) addresses retention. Compression (C) is a performance technique. Single gateway routing (D) may be an operational choice but is not the most critical integrity control.
Which of the following describes an 'automated interface' risk that is particularly relevant from a financial reporting perspective?
Explanation: Automated interfaces process large volumes of transactions; systematic errors in mapping logic (wrong account codes, wrong amounts, duplicates) can produce materially misstated financial data at scale before detection. Answer B is correct. Network latency (A), log storage (C), and programming language (D) are operational concerns, not financial reporting risks.
A batch interface file is transmitted from a subsidiary's accounting system to the corporate consolidation system. The file arrives but several records contain invalid account codes. Which control should have prevented this?
Explanation: Source-side validation controls should ensure records conform to required formats and valid values before the file is generated, preventing invalid data from being transmitted downstream. Answer C is correct. Firewalls (A) and digital signatures (B) address authentication and access. Encryption (D) protects confidentiality, not data validity.
Which of the following represents the most significant long-term risk of an organization having undocumented automated interfaces between its financial systems?
Explanation: Without documentation, it is impossible to effectively maintain, change, test, or audit an interface - creating long-term risk of undetected logic errors, unauthorized modifications, and control gaps affecting financial reporting. Answer D is correct. Documentation does not directly affect bandwidth (A), external attack vulnerability (B), or performance (C).
The primary purpose of interface controls between two systems is to:
Explanation: Interface controls govern data movement between systems, ensuring transfers are complete (no records lost), accurate (no data corruption), and authorized (only approved transfers occur). Answer A is correct. Encryption of stored data (B), user authentication (C), and network performance monitoring (D) are separate concerns.
A company receives supplier invoices via an EDI interface. The interface accepts invoices without validating that the purchase order referenced on each invoice exists in the company's purchasing system. This missing control exposes the company to:
Explanation: Without PO validation, the system may process and pay invoices for goods or services never ordered, creating a fraud and overpayment risk. Answer C is correct. Data loss from connection interruption (A) is a different risk. Encryption algorithms (B) and compression (D) are technical concerns unrelated to authorization validation.
During an interface run, 5,000 records are sent from the source system but only 4,985 records are received by the target system. Which of the following is the most likely cause and the appropriate control to detect this?
Explanation: Record count discrepancies are most commonly caused by transmission or processing failures. Record count reconciliation is the standard detective control that identifies the discrepancy. Answer D is correct. The cause could be any failure - disk space (A), encryption (B), or network (C) - but the applicable detective control is reconciliation, not technology-specific monitoring.