What is the purpose of referential integrity checks in testing data consistency?

To verify that data values are within an acceptable range.

To ensure that all required fields are populated.

To compare data between different systems.

To ensure that foreign key values in a table match primary key values in related tables.

How does data accuracy relate to the data quality dimension of completeness?

Completeness is a subset of accuracy; if data is accurate, it is automatically complete.

Accuracy and completeness are independent dimensions; data can be complete but inaccurate, or accurate but incomplete.

They are the same dimension; accuracy and completeness are interchangeable terms.

Accuracy is a subset of completeness; if data is complete, it is automatically accurate.

A financial institution is preparing for an audit. The audit team finds that customer addresses are stored differently in the loan system (e.g., 'St.' vs. 'Street') and the deposit system (e.g., 'Ave' vs. 'Avenue'). This causes customer statements to be mailed to incorrect addresses. What is the MOST EFFECTIVE data governance measure to prevent this issue?

Increase the frequency of data backups for both systems.

Assign a database administrator to manually correct address data each month.

Establish a data governance policy that defines a single standard for address formats across all systems.

Disable the address field in the deposit system to prevent future entries.

Which technique is specifically used to test data consistency across systems?

Cross-system comparison of data values.

Data validation against business rules.

Reconciliation of totals between source and target.

Data profiling to understand data distributions.

Which scenario is most likely to introduce data inaccuracy in a financial system?

A batch process that applies an incorrect currency conversion rate to transactions.

A scheduled backup that runs every night at 2 AM.

A user interface that displays data in a read-only format.

A network firewall that blocks access to the financial system from external IPs.

Certified Tester Finance Testing

Domain 4Objective 1

Data Accuracy and Data Consistency 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 38 practice questions to prepare you well beyond it. (estimate)

38questions here

8free pages

11concepts

Questions 26–30

26foundation · easy
What is the purpose of referential integrity checks in testing data consistency?
Select an answer first
27foundation · easy
How does data accuracy relate to the data quality dimension of completeness?
Select an answer first
28application · medium
A financial institution is preparing for an audit. The audit team finds that customer addresses are stored differently in the loan system (e.g., 'St.' vs. 'Street') and the deposit system (e.g., 'Ave' vs. 'Avenue'). This causes customer statements to be mailed to incorrect addresses. What is the MOST EFFECTIVE data governance measure to prevent this issue?
Select an answer first
29foundation · easy
Which technique is specifically used to test data consistency across systems?
Select an answer first
30foundation · easy
Which scenario is most likely to introduce data inaccuracy in a financial system?
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.