nerdexam
IIA

IIA-CIA-PART2 · Question #200

Which of the following approaches would best help an internal auditor determine whether a retailer database of 100,000 customers has nay duplicate accounts?

The correct answer is D. Sorting the customer information. Sorting the customer information is the most effective method for identifying duplicate accounts in a database of 100,000 customers. By sorting the database based on key identifiers such as customer name, address, or email, an internal auditor can quickly identify and review…

Performing the Engagement

Question

Which of the following approaches would best help an internal auditor determine whether a retailer database of 100,000 customers has nay duplicate accounts?

Options

  • AStratifying the customer information
  • BExtracting the customer information
  • CFiltering the customer information
  • DSorting the customer information

How the community answered

(38 responses)
  • B
    5% (2)
  • C
    3% (1)
  • D
    92% (35)

Explanation

Sorting the customer information is the most effective method for identifying duplicate accounts in a database of 100,000 customers. By sorting the database based on key identifiers such as customer name, address, or email, an internal auditor can quickly identify and review records that appear consecutively and have similar details, which is indicative of potential duplicates. This method is efficient and practical for handling large datasets.

Topics

#data analysis#duplicate detection#sorting techniques#CAATs

Community Discussion

No community discussion yet for this question.

Full IIA-CIA-PART2 Practice