Online Access Free 070-452 Practice Test

You design a Business Intelligence (BI) solution by using SQL Server 2008. The SQL Server 2008 Integration Services (SSIS) developers use a SQL Server 2008 instance as the primary development
environment.
All the SSIS packages contain data connection managers that use SQL Server authentication to extract
data. The packages are saved by using the EncryptAllWithUserKey package protection level.You plan a
package migration strategy from the development environment to a production environment. Migration will
be performed by using an automated script.
You need to ensure that the packages execute without error in the production environment.
What should you do?

• A.Export each package and change the package protection level to EncryptSensitiveWithPassword.
• B.Create a package configuration for every package that uses an XML configuration file.
• C.Create a package configuration for every package that uses a SQL Server table.
• D.Export each package and change the package protection level to DontSaveSensitive.

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.Upgrade the data extension to .NET Framework 3.5.
• C.Uninstall Internet Information Services (IIS).
• D.Edit the RSWebapplication.config file to refer to the upgraded SSRS endpoint location.

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution has been deployed by using default settings on a SQL Server 2008 Analysis Services (SSAS) instance. The solution has a large cube that processes 10 million fact rows. You frequently encounter out-of-memory exceptions when the cube is processed. You need to recommend a solution to resolve the out-of-memory exceptions when the cube is processed. You want to achieve this task by using the minimum amount of development effort. What should you do?

• A.Increase the physical memory available to the SSAS instance by modifying the OLAP\Process \BufferMemoryLimit server property.
• B.Partition the cube. Process the cube based on each partition.
• C.Reduce the number of aggregations.
• D.Increase the physical memory available to the SSAS instance by modifying the Memory \TotalMemoryLimit server property.

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

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to develop SQL Server 2008 Reporting Services (SSRS) reports. Several reports will contain identical data regions. You need to minimize the amount of maintenance when changes are made to the data regions. What should you do?

• A.Grant the Create Linked Reports role to all users.
• B.Create each data region as a report. Embed the reports by using the subreport control.
• C.Create a shared data source in the SSRS project. Use the new shared data source for all reports.
• D.Create a report template for each data region. Use the report template to create each report.