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

1. You are designing a SQL Server 2008 Integration Services (SSIS) package.
The package includes a Data Flow task that copies several million rows. The data flow requires a match
against a reference table that contains 10,000 rows. Each row in the reference table will be used during the
data flow.
Same row are not matching due to a mismatched case type
You need to ensure that the data flow executes to match all rows correctly.
Which data flow component should you select?

A) A Lookup transformation along with the Full cache option
B) A Lookup transformation along with the No cache option
C) A Lookup transformation along with the Partial cache option
D) A Fuzzy Lookup transformation

2. You are a server administrator of a SQL Server 2008 Analysis Services (SSAS) instance. The instance
contains a database that is used by the members of the Sales group.
You configure a new role named Northern Region by using the "{[Customers].[Region].[Region].[Northern]}"
allowed permission set.
You assign the Sales group to the Northern Region role.
You need to verify that users in the Northern Region role can view data only for their region.
What should you do?

A) Add the User ID=Northern Region; parameter to the connection string.
B) Temporarily add your account to the Northern Region role.
C) Add the Roles=Northern Region; parameter to the connection string.
D) Select the Enable Visual Totals check box for the Northern Region role.

3. You design a package by using SQL Server 2008 Integration Services (SSIS). The package is designed by
using your local development environment.
The package extracts data from a remote server and inserts it in the PROD database on the local SQL
Server 2008 instance. You deploy the package to the MSDB database on the production server.
You need to ensure that users can view, execute, and delete their own packages. What should you do?

A) Assign the users to the db_ssisoperator role.
B) Assign the users to the db_ssisltduser role.
C) Assign the users to the db_ssisadmin role.
D) Assign the users to a custom database role in the PROD database.

4. You administer a SQL Server 2008 Reporting Services (SSRS) instance.
The instance contains several reports that use stored credentials to access data from a SQL Server 2008 instance.
A computer that hosts the instance recovers from a hardware failure and has a newly installed SSRS instance.
You need to ensure that the reports hosted on the instance continue to function correctly.
What should you do?

A) Restore the encryption keys.
B) Recreate the Report Server database.
C) Recreate the encryption keys.
D) Reinitialize the Report Server.

5. You maintain a SQL Server 2008 Analysis Services (SSAS) database.
When you process the Analysis Services database using the Process Add option in Management Studio, you discover that a KeyNotFound error occurs.
You need to modify the ErrorConfiguration property so that the error condition id reported and processing continues.
Which object should you modify?

A) Partition
B) Cube
C) Measure group
D) Dimension

Solutions: