More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
Report Builder has no built in support for source control. Which of the following choices could be implemented if you decided that those reports needed to be under source control?
Answer
Have users save the RDL files locally and check into source control using a source control utility, or write code to script them out each night and check them into source control
Explanation
Users can do faux source control by just saving copies of their RDL files locally before they make a change. Beyond that, you either teach them how to use a source control utility or you write a utility you can run on a schedule.
(Continued on next question...)