Online Access Free 070-452 Exam Questions

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 a line component between the report items for the Agency and State summary sections.
• B.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.
• C.Select the Keep together on one page option on all report items.
• 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 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.Partition the cube. Process the cube based on each partition.
• B.Increase the physical memory available to the SSAS instance by modifying the OLAP\Process \BufferMemoryLimit server property.
• C.Reduce the number of aggregations.
• D.Increase the physical memory available to the SSAS instance by modifying the Memory \TotalMemoryLimit server property.

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution will contain a total
of 100 different reports created by using Report Definition Language (RDL).
Each report must meet the following requirements:
-Display a common set of calculations based on a parameter value.
-Provide a method for setting values on a report URL or in a subscription definition that are not exposed to a
user.
-The business rules for all reports that determine the calculations change frequently.
You need to design a solution that meets the requirements. You need to perform this action by using the
minimum amount of development and maintenance effort.
What should you do?

• A.Create hidden parameters in each report.
• B.Implement the function in a custom assembly. Reference the assembly in each report.
• C.Create internal parameters in each report.
• D.Implement the function in the <Code> element of each report.

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.Create a package configuration for every package that uses an XML configuration file.
• B.Export each package and change the package protection level to EncryptSensitiveWithPassword.
• 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 are a SQL Server 2008 Analysis Services (SSAS) data mining architect. The customer table contains the following column names: -Customer_key -Name -Age
-Education Level
-IsBuyer
You plan to build a data mining model by using Microsoft Decision Trees algorithm for the customer
table.
You need to identify the data columnmodel parameter pairs to predict possible buyers.
Which model should you select?

• A.Data Column Model Parameter Type Customer_key Input Name Ignore Education Level Input, Predict Age Input, Predict IsBuyer Key
• B.Data Column Model Parameter Type Customer_key Input Name Ignore Education Level Input Age Input IsBuyer Key
• C.Data Column Model Parameter Type Customer_key Key Name Ignore Education Level Input Age Input IsBuyer Predict
• D.Data Column Model Parameter Type Customer_key Predict Name Key Education Level Input Age Input IsBuyer Input