What tool is available for ad hoc reporting by n

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

(Continued from previous question...)

What tool is available for ad hoc reporting by non IT end users in Reporting Services 2005?

Answer
Report Builder

Explanation
Report Builder is bundled as part of Reporting Services 2005 and is targeted at end users needing to build ad hoc reports. BI Design Studio could be used, but typically requires more time and experience to use than the average end user will be willing to invest.

(Continued on next question...)

Other Job Interview Questions

• Where does Profiler store its temporary data in SQL Server 2005?
• If you have a replication scenario with one publisher, one distributor and one subscriber and the transaction isolation level is not set to serializable, what happens when a transaction fails on the publisher?
• What does the PAD_INDEX parameter do when you create an index in SQL Server 2005?
• Which RAID levels store parity information?
• In SQL Server 2005, what does instance aware mean for a service?
• Which of the following datatypes can be represented in a SQL_VARIANT datatype?
• In SQL Server 2005 T-SQL, what does the CONTINUE statement do?
• To optimize the configuration of tempdb for performance, what setting should be used for the tempdb recovery model?
• Where is varchar(max) data stored?
• What does a @@fetch_status of -2 mean in SQL Server 2005?
• More...