Data Accuracy and Data Consistency CT-FT Practice Questions (Page 1)

Questions 1–5

1. 1application · medium

   A company runs its payroll in a legacy system and its general ledger in a modern cloud ERP. The test team is verifying that the total salary expense posted in the general ledger matches the sum of individual employee salaries in the payroll system. Which test technique is BEST suited for this task?

   • APerform a cross-system comparison of the total salary expense and the sum of payroll records.
   • BReview the data governance policy for the general ledger chart of accounts.
   • CTest the referential integrity of the employee ID in the payroll system.
   • DRun a data validation rule to ensure all salary amounts are positive numbers.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A financial services firm is testing a new trade settlement system. The test lead wants to verify that the 'Total Trade Value' field in the settlement report matches the sum of individual trade records in the database. Which technique is MOST appropriate for this verification?

   • AValidate that all trade records have a non-null settlement date.
   • BPerform a reconciliation between the report total and the sum of the underlying transaction records.
   • CReview the data governance policy for trade data entry.
   • DCheck the referential integrity between the trade table and the counterparty table.
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A company is implementing a new financial reporting system. To maintain data consistency between the new system and the existing ERP, the project team decides to use a master data management (MDM) solution. What is the PRIMARY benefit of this data management practice?

   • AIt eliminates the need for data reconciliation testing.
   • BIt provides a single, authoritative source for master data, such as customer and product information, used by all systems.
   • CIt increases the storage capacity of the data warehouse.
   • DIt automatically generates test data for the new system.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   What is a typical source of data inconsistency across financial systems?

   • ARegularly reconciling data between systems.
   • BHaving a single source of truth for all financial data.
   • CUsing the same database schema in all systems.
   • DDifferent systems updating the same data element at different times without synchronization.
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   How does data governance help prevent data inconsistency?

   • ABy focusing only on data security and access control.
   • BBy establishing data standards and ownership to ensure consistent data definitions and updates.
   • CBy allowing each department to define its own data rules.
   • DBy increasing the number of systems that store the same data.
   Reveal Solution Discussion Select an answer first