Set - 2

Question 11 :

How can SQL Server Agent Mail send messages in SQL Server 2005?

Answer :

SQL Mail through Extended MAPI or Database mail.
SQL Server Agent Mail can be configured to use Database Mail or Extended MAPI.

Question 12 :

What is the scale of measurement for the cost threshold for parallelism setting in SQL Server 2005?

Answer :

This value measures the number of seconds for a plan where the optimizer chooses between serial and parallel plans.

Question 13 :

Which of the following statements best describes the filter capabilities of Report Builder?

Answer :

Users can do equals, greater than, less than, etc, plus they can do logical AND, OR, NOT operations. Users can also group filters to allow more advanced filters.
While it looks a little different than you may be used to, the filter builder is reasonably rich, allowing most standard evaluation types and rich boolean comparisons. The only weak spot in the set is no support for LIKE, you have to make do with CONTAINS.

Question 14 :

True or false, Report Builder supports user defined run time parameters?

Answer :

Absolutely true. Users can define any portion of a filter to be a run time prompt, letting other users easily change the filter as needed. Not only is it easy to set up, Report Builder automatically populates a list of all possible choices based on the column being filtered.

Question 15 :

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
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.