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

1. You create a report by using SQL Server 2008 Reporting Services (SSRS).
The report is complex and takes several minutes to generate.
You need to configure the report server to run in the morning and have the users access that copy of the
report for the remainder of the day.
What should you do?

A) Implement report snapshots
B) Configure the data source to use snapshot isolation
C) Implement report execution caching
D) Configure the data source to use a database snapshot

2. You manage the security in SQL Server 2008 R2 Reporting Services (SSRS).
You create a new role.
You need to grant the following permissions to the role:
View and modify security settings for reports, folders, resources, and shared data sources.
Create and delete reports.
Modify report properties.
View content, definition, and property for reports.
Which three actions should you perform? (Each correct answer presents part of the solution, Choose
three.)

A) Assign the Manage All Subscriptions task to the role.
B) Assign the Consume Reports task to the role.
C) Assign the Manage Resources task to the role.
D) Assign the Manage Reports task to the role.
E) Assign Set Security Policies for Items task to the role.

3. You maintain a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to run the Usage-Based Optimization Wizard.
You need to enable query logging.
What should you do?

A) Set the QueryLogConnectionString server property to a valid connection string.
B) Set the LogDir server property to a valid path.
C) Set the AllowedBrowsingFolders server property to include the folder from the LogDir setting.
D) Set the QueryLogSampling server property to 10.

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 your account temporarily to the Engineering and Design role.
C) Add the User ID = [Engineering and Design]; parameter to the connection string.
D) Select the Enable Visual Totals check box for the Engineering and Design role.

5. You design a report by using SQL Server 2008 Reporting Services (SSRS).
The report will be included in a Windows Forms application that is distributed to remote users. These users
have no access to the report server.
You need to ensure that the application renders the report correctly.
What should you do?

A) Use the Render method of the Reporting Services Simple Object Access Protocol (SOAP) API.
B) Use the RenderStream method of the Reporting Services Simple Object Access Protocol (SOAP) API.
C) Use the ReportViewer control along with the LocalReport property.
D) Use the ReportViewer control along with the RemoteReport property.

Solutions: