CompTIA Data+ (DA0-001) — Question 109

A user imports a data file into the accounts payable system each day. On a regular basis, the field input is not what the system is expecting, so it results in an error for the row and a broken import process. To resolve the issue, the user opens the file, finds the error in the row, and manually corrects it before attempting the import again. The import sometimes breaks on subsequent attempts, though.

Which of the following changes should be made to this process to reduce the number of errors?

Answer options

• A. Delete all incorrect inputs and upload the corrected file.
• B. Have the user manually review the file for data completeness before loading it.
• C. Create a data field to data type validator to run the file through prior to import.
• D. Spot-check the file prior to import to catch and correct field errors.

Correct answer: C

Explanation

Creating a data field to data type validator to run the file through prior to import (Option C) is the best way to ensure data integrity and prevent errors from occurring during the import process. Options A and B do not address the root cause of the data input issues, while Option D, while helpful, does not provide a systematic solution to catch all errors before the import.