Q: What is the process of tracking changes, additions, deletions, and errors during data cleaning?
or
Q: How are additions, deletions, modifications, and mistakes monitored throughout the data cleaning process?
- Recording
- Observation
- Cataloging
- Documentation
Explanation: Data auditing or data lineage refers to the act of tracing the history of a set of data, including its modifications, additions, removals, and mistakes, while cleansing the data. It requires recording and keeping a record of any changes, additions, deletions, or corrections that were made to the dataset. These modifications might include anything from the list above. Having an audit trail provides significant benefits in terms of transparency, repeatability, and comprehension of the development of the data during the process of cleaning them.
