Online Access Free 070-452 Practice Test

You design a Business Intelligence (BI) solution by using SQL Server 2008. You have deployed a SQL
Server 2008 Reporting Services (SSRS) application. The number of users for the SSRS application
increases. This results in performance problems. The datasets for the reports are optimized.
You investigate the SSRS deployment and discover the following characteristics:
-Users report that the reports take a long time to run.
-There are a large number of graphical reports that summarize data.
-Subscription processing affects the performance of reports that are run by interactive users.
You need to modify the SSRS infrastructure to resolve the performance problems.
Which scale-out strategy should you use?

• A.Multiple SSRS servers and multiple reporting database servers
• B.Single SSRS server and multiple reporting database servers
• C.Single SSRS server and a single reporting database server
• D.Multiple SSRS servers and a single reporting database server

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to create a SQL
Server 2008 Reporting Services (SSRS) solution. Developers generate random reports against a data
source that contains 200 tables. Power users generate random reports against four of the 200 tables. You
need to design a strategy for the SSRS solution to meet the following requirements:
-Uses minimum amount of development effort.
-Provides two sets of tables in SSRS to the developers group and the power users group.
Which strategy should you use?

• A.Create two Report Builder models. Include the four frequently used tables in the first model and all the tables in the second model.
• B.Create a Report Builder model by using all the tables. Create a perspective within the model to use only the four frequently used tables.
• C.Create a Report Builder model by using all the tables. Create two folders. Place the four frequently used tables in the first folder and the remaining tables in the second folder.
• D.Create two Data Source Views. Include all the tables in one Data Source View and the four frequently used tables in the other Data Source View. Create two Report Builder models so that each model uses one of the Data Source Views.

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 OLE DB Command transform in the data flow with an Execute SQL task in the control flow.
• 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 UPDATE statement in the OLE DB Command transform with a DELETE statement followed by an INSERT statement.

You design a Business Intelligence (BI) solution by using SQL Server 2008. You develop 10 SQL Server
2008 Integration Services (SSIS) packages. You plan to include package configuration for all the packages.
The package configuration has the following requirements:
-All configurations are stored in a single location.
-Configuration variables are easily backed up and restored.
-Indirect configuration is used.
-The database administrators will use SQL Server client tools to change the configuration values.
You need to create package configurations for the packages to meet the configuration requirements.
What should you do?

• A.Store all configuration information in a SQL Server table. Specify configuration database connectivity settings in an environment variable.
• B.Use XML configuration files for all packages. Store each XML configuration file in a common folder. Specify the XML configuration file location in an environment variable.
• C.Use XML configuration files for all packages. Store each XML configuration file in a common folder. Specify the XML configuration file location in the configuration settings.
• D.Store all configuration information in a SQL Server table. Specify configuration database connectivity settings in the SQL Server table.

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 data source views for the SSAS solution.
• B.You should create multiple data sources for the SSAS solution.
• C.You should create multiple named queries for the SSAS solution.
• D.You should create multiple database views for the source database.