Using Report Builder that is bundled with Report

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

(Continued from previous question...)

Using Report Builder that is bundled with Reporting Services 2005, which of the following would work as a way to add a derived field to a report?

Answer
Add a field to the model in Report Builder using the built in formula/function support

Explanation
While Report Builder cannot be used to build or maintain models, it does allow you to add a virtual field that exists only within that report - to the end user it looks like the model is being modified.

(Continued on next question...)

Other Job Interview Questions

• Where are Notification Services event messages logged in SQL Server 2005?
• In the SQL Server 2005 thesaurus XML configuration file, what is the expansion set?
• What does HAS_DBACCESS() do?
• 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?
• Which of the following choices show the three report formats supported by Report Builder
• True or false, Report Builder offers direct export to a Microsoft Access database as one of its supported export options?
• Which key provides the strongest encryption?
• What does the ERROR_PROCEDURE() function return?
• You want to be sure your database server if properly secured. You have two instances, a default instance and a named instance installed. Which ports do you need to open?
• What security role should you assign them?
• More...