When a discrepancy is found during reconciliation, what is the first step in investigating it?

Immediately correct the data in the target system.

Escalate the issue to senior management.

Delete the record from the source system.

Gather relevant details about the discrepancy, such as the record identifier and the systems involved.

Which of the following is a common tool used to automate data reconciliation?

Reconciliation software such as BlackLine or Trintech

What is the correct sequence of steps in the data reconciliation process?

Discrepancy resolution, data extraction, comparison

Data extraction, comparison, discrepancy resolution

Comparison, data extraction, discrepancy resolution

Data extraction, discrepancy resolution, comparison

A bank's core banking system records daily account balances, while the general ledger (GL) records the same balances at a higher aggregation level. During reconciliation, the tester notices that the sum of all customer account balances in the core system matches the GL total, but individual account balances differ between the two systems. What is the most appropriate reconciliation type to use to detect this issue?

Data quality profiling to assess completeness and accuracy

Balance-level reconciliation comparing account balances

Transaction-level reconciliation matching each individual transaction

Aggregate-level reconciliation comparing total balances

What should an audit trail for data reconciliation include?

The database schema of the source systems.

Timestamps, user IDs, and details of the reconciliation steps performed.

Only the final reconciliation report.

The passwords of users who performed the reconciliation.

Certified Tester Finance Testing

Domain 4Objective 2

Data Reconciliation Across Financial Systems CT-FT Practice Questions (Page 6)

Part of the Data Testing and Data Management domain, which makes up ~14% of our current practice bank. ISTQB does not publish an official question count, but from its 60-minute exam (~25–40 total, ~4–6 in this domain), expect 1–2 from this objective — we provide 32 practice questions to prepare you well beyond it. (estimate)

32questions here

7free pages

10concepts

Questions 26–30

26foundation · easy
When a discrepancy is found during reconciliation, what is the first step in investigating it?
Select an answer first
27foundation · easy
Which of the following is a common tool used to automate data reconciliation?
Select an answer first
28foundation · easy
What is the correct sequence of steps in the data reconciliation process?
Select an answer first
29application · medium
A bank's core banking system records daily account balances, while the general ledger (GL) records the same balances at a higher aggregation level. During reconciliation, the tester notices that the sum of all customer account balances in the core system matches the GL total, but individual account balances differ between the two systems. What is the most appropriate reconciliation type to use to detect this issue?
Select an answer first
30foundation · easy
What should an audit trail for data reconciliation include?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to CT-FT

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by ISTQB. “CT-FT” is a trademark of its owner, used for identification only.