Q: You start a complex project that will take more than a year to complete. You need to document modifications made to your queries throughout the project. What is the correct way to store these modifications?
or
Q: You begin an intricate undertaking that will need more than a year to finish. If you make changes to your queries throughout the project, you must record them. In what manner should I preserve these modifications?
- Creating a changelog
- Creating a notepad
- Visualizing data
- Creating a spreadsheet
Explanation: Utilizing version control systems like Git is the right technique to save changes that are made to your query throughout a long-term project. You will be able to communicate with others on the project and monitor changes to your code (including SQL queries) over time by using version control systems. You will also be able to preserve a history of the alterations made. A commit message that explains the changes that were made to the project is often included with each set of updates. This helps to maintain an accurate and well-organized record of the development of the project.
