CFE – Investigation — Question 73

Which of the following data analysis functions is used to match data in a transaction file with records in a master file, such as matching invoice data in an accounts payable file to a master list of approved vendors?

Answer options

• A. The compliance verification function
• B. The gap testing function
• C. The Join function
• D. The correlation analysis function

Correct answer: C

Explanation

The Join function is specifically designed to combine records from two data sources based on a common field, such as matching invoices to vendor records. The compliance verification function checks adherence to standards, gap testing identifies discrepancies, and correlation analysis evaluates relationships between variables, none of which directly perform the matching task described.