Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan Sample Questions:

1. You maintain a report in a SQL Server 2008 Reporting Services (SSRS) instance.
The report contains query parameters that allow users to filter the contents of the report.
The report requires users to enter parameter values before it will run.
The users wish to simplify the process so that the report will run without input.
You need to enable this functionality.
What should you do?

A) Remove the filters from the dataset queries and use the parameters to filter the data source.
B) Move the queries to the stored procedures and use the stored procedures to populate and filter the datasets of the report.
C) Add a default value to all parameters
D) Modify the dataset to use the Table query type.

2. You create a SQL Server 2008 Analysis Services (SSAS) solution.
The solution has the following components:
A dimension named DimTime that contains an attribute named Month
A measure group named FactSales that references the DimTime dimension
You need to ensure that the aggregations designed on FactSales always include the Month attribute.
What should you do?

A) Set the AttributeHierarchyEnabled property appropriately.
B) Set the IsAggregatable property appropriately.
C) Set the Usage property appropriately.
D) Set the AggregationUsage property appropriately.

3. You create a SQL Server 2008 Analysis Services (SSAS) solution. You enable proactive caching for a partition.
You need maintain SSAS performance by preventing the partition from entering ROLAP mode. What should you do?

A) Set the ProcessingMode property for the partition to Regular.
B) Set the ProcessingMode property for the partition to LazyAggregations.
C) Set the OnlineMode property for thepartition to OncacheComplete.
D) Set the OnlineMode property for the partition to Immediate.

4. You maintain a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains a database
that is used by the members of the Engineering group.
You configure a new role named Engineering and Design by using the following allowed permission set:
{[Employees].[Department].[Engineering and Design]}
You assign the Engineering group to the Engineering and Design role.
You need to ensure that users in the Engineering and Design role can view data only for their department.
What should you do?

A) Add the Roles = [Engineering and Design]; parameter to the connection string.
B) Add the User ID = [Engineering and Design]; parameter to the connection string.
C) Add your account temporarily to the Engineering and Design role.
D) Select the Enable Visual Totals check box for the Engineering and Design role.

5. You are an ETL developer. You maintain a SQL Server 2008 Integration Services (SSIS) instance.
You need to develop a parent package that meets the following requirements:
The parent package can execute child packages by using multiple execute Package tasks.
A notification needs to be sent before executing the parent package and after executing all child packages.
If any packages have errors during execution, the subsequent package should run after the failure.
Only one error notification email should be sent that lists all package errors from the parent package.
What should you do? (Each correct answer presents part of the solution. Choose three.)

A) A Add a Send Mail Task to the child packages' OnPostExecution event handler.
B) Add a Send Mail Task to the child packages' OnPostExecution event handler.
C) Set the precedence constraints between child packages to success.
D) dd a Send Mail Task to the parent packages' OnError event handler.
E) Set the precedence constraints between child packages Completion.

Solutions: