Question

Which of the following is a control plan that controls the entry of data by defining the acceptable format of each data field?

1) Data dictionary
2) Data validation
3) Data transformation
4) Data integration

Answer 1

Data validation is a control plan that checks data for errors by defining the acceptable format of each data field.

Step-by-step explanation:

The correct option is 2) Data validation. Data validation is a control plan that ensures data integrity by checking the data for errors and correctness before it is processed. It controls the entry of data by defining the acceptable format of each data field. For example, in a form that requires a user to enter their date of birth, data validation rules can enforce that the input must be in a date format such as DD/MM/YYYY, and it might also ensure that the date is realistic (e.g., not a future date).