Online Access Free 070-452 Exam Questions

You design a Business Intelligence (BI) solution by using SQL Server 2008. A SQL Server 2008 Analysis
Services (SSAS) solution contains a cube that has the following objects:
Dimensions named DimCustomer, DimProduct, and DimGeography Measures named InternetSales and
TotalSales
Users run reports against all dimensions and measures by authenticating with their Windows accounts.
You need to provide a basic view of data to the users to display only DimGeography, DimProduct, and
TotalSales by using the least amount of storage space.
What should you do?

• A.Create a new data source view. dd the tables used for DimGeography, DimProduct, and TotalSales.
• B.Create a new role. Grant access only to DimGeography, DimProduct, and TotalSales.
• C.Create a new perspective for the current cube. Select DimGeography, DimProduct, and TotalSales.
• D.Create a new cube. Add DimGeography, DimProduct, and TotalSales.

You design a Business Intelligence (BI) solution by using SQL Server 2008. Users have no specialized
knowledge of the Transact-SQL (T-SQL) language.
You plan to create a reporting solution by using SQL Server 2008 Reporting Services (SSRS). You have
data stored in a SQL Server 2008 relational data warehouse. You need to ensure that users are able to
create the necessary reports by using data from the data warehouse.
What should you do?

• A.Create a shared data source that points to the data warehouse. Instruct the users to use Report Designer in Business Intelligence Development Studio (BIDS) to create the reports by using the shared data source.
• B.Create a shared data source that point to the data warehouse. Instruct the users to use Report Builder 2.0 to create the reports by using the shared data source.
• C.Create a Report Model from the data warehouse. Instruct the users to use Report Builder 2.0 to create the reports by using the Report Model.
• D.Create a Report Model from the data warehouse. Instruct the users to use Report Designer in Business Intelligence Development Studio (BIDS) to create the reports by using the Report Model.

You administer a Microsoft SQL Server 2005 Reporting Services (SSRS) instance.
The instance has the following features:
-Deployed as a single server
-Configured to use Native mode
-A custom data extension developed by using Microsoft .NET Framework 2.0
You plan to upgrade the instance to SQL Server 2008 Reporting Services. You need to upgrade the
instance without loss of functionality.
What should you do?

• A.Install a new instance of SSRS. Migrate the existing configuration files and database to the new instance.
• B.Uninstall Internet Information Services (IIS).
• C.Edit the RSWebapplication.config file to refer to the upgraded SSRS endpoint location.
• D.Upgrade the data extension to .NET Framework 3.5.

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to deploy a new SQL
Server 2008 Reporting Services (SSRS) solution for an accounting department. The department currently
uses Microsoft Excel 2007based reports hosted on Windows SharePoint Services (WSS) 3.0.
You need to replace the existing Excel 2007 reports with SSRS-based reports.
Your solution must meet the following requirements:
-Users must be able to access the reports by using WSS.
-Reports must be version-controlled.
-Developers must be able to deploy the reports to a WSS document library.
Which two tasks should you perform? (Each correct answer presents part of the solution. Choose two.)

• A.Install SharePoint Web Part in the WSS server. Configure the Web Part to point to the reports in Report Manager.
• B.Install the Reporting Services Add-in for SharePoint Technologies in the WSS server.
• C.Configure the SSRS instance by using SharePoint integration mode.
• D.Configure the SSRS instance by using native mode.

You design a Business Intelligence (BI) solution by using SQL Server 2008. You have a SQL Server 2008
Analysis Services (SSAS) cube. Some users only use Microsoft Excel 2007.
Some users only use Microsoft ProClarity.
You plan to add new key performance indicators (KPIs). You need to ensure that the KPIs meet the
following requirements:
-Provide all users access to the new KPIs.
-Minimize future maintenance.
What should you do?

• A.Create the KPIs in the Excel spreadsheets.
• B.Create SQL Server 2008 Reporting Services (SSRS) reports that contain the expected KPIs.
• C.Create the KPIs in ProClarity.
• D.Create the KPIs in the SSAS cube.