Q: You use SQL to clean your data. You make comments whenever you modify your queries to keep track of any changes. What documentation will this practice help you create when you’re done cleaning the data?
or
Q: To sanitize your data, you utilize SQL. To keep track of any modifications, you add comments to your queries as you make changes. After you’ve finished cleansing the data, what documents will this process assist you in producing?
- A changelog
- A query repository
- A new dataset
- A database
Explanation: You may produce documentation that functions as a changelog or version history by getting into the habit of inserting comments in your SQL queries to keep track of changes. This will help you write documentation more efficiently. These comments provide a record of the alterations that were made to the queries throughout the process of data cleaning. They also explain the thinking that went into making the modifications. This documentation helps understand how the queries have evolved, diagnosing problems, and ensuring that the data cleaning process is transparent and reproducible.
