Clicking File, Save in Report Builder does which

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Clicking File, Save in Report Builder does which of the following?

Answer
Saves the report to the report server

Explanation
File|Save writes the report to the Report Server. Users have the option to also save the report to disk by using File|Save to File. Report Builder users cannot modify the model.

(Continued on next question...)

Other Job Interview Questions

• You want to disable the receipt of messages in one of your databases by the Service Broken. How should you do this?
• You are troubleshooting a Service Broker application ...
• What security role should you assign them?
• What is row versioning in SQL Server 2005?
• Which utility is used to administer SQL Server 2005 Notification Services instances?
• Which is larger in size in SQL Server 2005 if you are using symmetric keys?
• You are looking to secure your publisher to prevent unauthorized logins from accessing the data through replication. Where do you add the list of logins that have access?
• Out of the box Report Builder supports two report level fields that can be shown on a report. Which option below has those two options?
• What does this return?
• What does CONTINUE do in T-SQL?
• More...