070-452 무료 덤프문제 온라인 액세스

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008
Reporting Services (SSRS) report.
The report contains summary information in two sections named Agencies and States. The Agency
summary section contains two matrices and the State summary section contains a table. The information
about each section is grouped together.
You need to design the report to meet the following requirements:
-When the report is exported to a Microsoft Excel spreadsheet, each summary section is rendered to a
separate tab.
-The structure in each section is retained.
What should you do?

• A.Select the Keep together on one page option on all report items.
• B.Select a line component between the report items for the Agency and State summary sections.
• C.Select all the report items for each section in a list report item and enable the Add A Page Break Before option on the list report item.
• D.Select all the report items for each section in a rectangle report item and enable the Add A Page Break Before option on the rectangle report item.

You are creating a SQL Server 2008 Reporting Services (SSRS) solution for a company that has offices in
different countries. The company has a data server for each country. Sales data for each country is
persisted in the respective data server for the country. Report developers have only Read access to all data
servers. All data servers have the same schema for the database.
You design an SSRS solution to view sales data.
You need to ensure that users are able to easily switch between sales data for different countries.
What should you do?

• A.Implement an embedded data source that has a static connection string.
• B.Implement multiple shared data sources.
• C.Implement a single shared data source.
• D.Implement an embedded data source that has an expression-based connection string.

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008
Integration Services (SSIS) package to perform an extract, transform, and load (ETL) process to load data
to a DimCustomer dimension table that contains 1 million rows.
Your data flow uses the following components:
-A SQL Destination data flow task to insert new customers.
-An OLE DB Command transform that updates existing customers.
On average, 25 percent of existing customer records is updated each night. You need to reduce the
amount of time required to update customer records.
What should you do?

• A.Modify the UPDATE statement in the OLE DB Command transform to use the TABLOCK table hint.
• B.Stage the data in the data flow. Replace the UPDATE statement in the OLE DB Command transform with a DELETE statement followed by an INSERT statement.
• C.Modify the UPDATE statement in the OLE DB Command transform to use the PAGLOCK table hint.
• D.Stage the data in the data flow. Replace the OLE DB Command transform in the data flow with an Execute SQL task in the control flow.

You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. You use SQL Server 2008 to work out a SQL Server 2008 Analysis Services (SSAS) solution. A source database which contains a table named Client is tilized in the solution. And the Client table contains lots ofcolumns. You have read-only access to the database. You intend to cut down the number of columns in the Client table. You have to split the Client table to be distributed across multiple table definitions. So what should you do?

• A.You should create multiple database views for the source database.
• B.You should create multiple named queries for the SSAS solution.
• C.You should create multiple data source views for the SSAS solution.
• D.You should create multiple data sources for the SSAS solution.

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 SQL Server 2008 Reporting Services (SSRS) reports that contain the expected KPIs.
• B.Create the KPIs in the Excel spreadsheets.
• C.Create the KPIs in ProClarity.
• D.Create the KPIs in the SSAS cube.