Microsoft PRO:MS SQL Server 2008, Designing a Business Intelligence Sample Questions:

1. You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design a report that
uses data obtained from a SQL Server 2008 Analysis Services (SSAS) instance.
The SSAS cube contains five parentchild key performance indicators (KPIs). Each KPI has nine children.
You need to create an executive dashboard in Microsoft Office SharePoint Server (MOSS) that displays
the KPIs and depicts the parentchild relationship.
Which technology should you use?

A) Microsoft Office PerformancePoint Server
B) Microsoft Office Excel
C) MOSS Business Data Catalog
D) MOSS KPI Library

2. You are the administrator of your company network. You use Server 2008 to develop a Business Intelligence (BI) solution. You work out a SQL Server 2008 Analysis Services (SSAS) solution. Customer data is stored in the tables named CustomerContact and CustomerDetails. The solution utilizes the following two data sources from two different servers: ContosoCRM that accesses the CustomerContact table Contoso that accesses the CustomerDetails tableYou intend to create a dimension named DimCustomer that analyzes customer data. You have to make sure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables. So what should you do to ensure this?

A) Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and add the CustomerContact table to
B) You should create a data source view named DsvCustomer which is associated with the Contoso data source and add the CustomerDetails table to the data
C) You should create a data source view named DsvContoso which is associated with the two data sources and add the tables to the data source view.
D) Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and
E) You should create a data source view named DsvCustomer which is associated with the
Contoso data source and create a named query in the data source view to
F) You should create a data source view named DsvContoso which is associated with the two data sources and create a named query in the data source view to

3. You design a Business Intelligence (BI) solution by using SQL Server 2008. You have developed SQL
Server 2008 Reporting Services (SSRS) reports that are deployed on an SSRS instance.
You plan to develop a new application to view the reports. The application will be developed by using
Microsoft ASP.NET 3.5.
You need to ensure that the application can perform the following tasks:
-Display available reports in a tree view control.
-Create and manage subscriptions on reports.
What should you do?

A) Embed a ReportViewer control in the ASP.NET application. Configure the control to use the remote processing mode.
B) Configure the ASP.NET application to use URL access along with the Command parameter.
C) Configure the ASP.NET application to use the SSRS Web service.
D) Embed a ReportViewer control in the ASP.NET application. Configure the control to use the local processing mode.

4. You design a Business Intelligence (BI) solution by using SQL Server 2008. Employees use a Windows
Forms application based on Microsoft .NET Framework 3.5. SQL Server is not installed on the employees'
computers.
You write a report by using Report Definition Language (RDL). You need to ensure that if the employees
are disconnected from the corporate network, the application renders the report.
What should you do?

A) Embed ReportViewer in the application and configure ReportViewer to render reports by using the local processing mode.
B) Configure the application to use an SSRS Web service by using the Render method.
C) Embed ReportViewer in the application and configure ReportViewer to render reports by using the remote processing mode.
D) Configure the application to use an SSRS Web service by using the RenderStream method.

5. You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to deploy a new
database to the SQL Server 2008 Analysis Services (SSAS) instance. The database contains a cube. The
cube contains three Type 1 slowly changing dimensions. The database is updated throughout the day by
adding 5,000 rows of data every hour. You need to ensure that the cube always contains up-to-date data.
You also need to ensure that the users can access the cube during cube processing.
What should you do?

A) Use the hybrid online analytical processing (HOLAP) cube storage model. Use SQL Server 2008 Integration Services (SSIS) pipeline tasks to schedule periodic cube updates.
B) Use the hybrid online analytical processing (HOLAP) cube storage model. Use the snapshot isolation level in the relational database that the cube is built on.
C) Use the relational online analytical processing (ROLAP) cube storage model.
D) Use the automatic multidimensional online analytical processing (MOLAP) cube storage model.

Solutions: