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

Questions 6–10

1. 6application · medium

   A company has multiple systems that store customer data. The data quality team finds that the same customer has different phone numbers in the CRM, billing, and support systems. To resolve this, the company decides to implement a data governance program. What is the FIRST step in this program to address this issue?

   • AImmediately correct the phone numbers in all three systems.
   • BDefine data standards and policies for customer data, including a single source of truth for phone numbers.
   • CHire more data entry staff to manually verify phone numbers.
   • DPurchase a new CRM system to replace the existing ones.
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A company's risk management team uses a data warehouse for reporting. The warehouse is refreshed nightly from the operational CRM. On a particular day, the risk team runs a report at 10:00 AM and sees 1,000 open customer complaints, while the CRM system shows 1,200. The discrepancy is traced to the nightly refresh schedule. What is the MOST LIKELY cause of this data inconsistency?

   • AThe CRM system has a data accuracy issue with the complaint records.
   • BThe data warehouse has a referential integrity problem with the complaint table.
   • CThe risk team is using a different definition of 'open complaint' than the CRM system.
   • DThe data warehouse is not updated in real-time, so it does not reflect changes made after the last refresh.
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   Which of the following is a common source of data inaccuracy in financial systems?

   • AManual data entry errors, such as transposing digits in an account number.
   • BHaving too many users with access to the system.
   • CStoring data in multiple formats like CSV and XML.
   • DUsing different database vendors for different systems.
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A tester is comparing the 'Customer Status' field (e.g., 'Active', 'Inactive') between the CRM and the Billing system. The CRM shows a customer as 'Active', but the Billing system shows the same customer as 'Inactive'. Both systems have the correct value according to their own business rules. What is the BEST description of this situation?

   • AA data consistency issue, because the same logical data point is represented differently in two systems.
   • BA data accuracy issue, because the CRM value is incorrect.
   • CA data completeness issue, because one system is missing the status field.
   • DA data timeliness issue, because the data was updated at different times.
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Why is data accuracy particularly important in the context of financial systems?

   • ABecause financial systems must process data faster than any other business system.
   • BBecause financial systems require data to be stored in a specific database format.
   • CBecause financial data is always stored in the cloud and must be protected from hackers.
   • DBecause financial decisions and regulatory reports rely on correct data to avoid misstatements and penalties.
   Reveal Solution Discussion Select an answer first