Which of the following approaches would best help an internal auditor determine whether a retailer database of 100,000 customers has nay duplicate accounts?
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.
[References:, Internal Audit Data Analytics Techniques, Database Management Best Practices, , , ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit