Online Access Free 70-452 Practice Test

You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. All transaction data of your company is processed in a Point of Sale (POS) application. You work out a solution on the basis of the transaction data, in order to foretell which type of products a customer may buy on a single visit. You have to select the suitable algorithm to design the solution. So which algorithm should you choose?

• A.You should use Clustering
• B.You should use Time Series
• C.You should use Naive Bayes
• D.You should use Association Rules

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Analysis Services (SSAS) solution. Your database has a table named DimCustomer that contains columns named FirstName and LastName. You belong only to the db_datareader role in the database. You have added DimCustomer to a data source view. You need to design a solution that includes the following requirements: -A column named FullName in DimCustomer by using the values from FirstName and Lastname -The data source view allows you to delete columns from DimCustomer
What should you do?

• A.Redesign DimCustomer to have a computed column named FullName.
• B.Replace DimCustomer with a named query in the data source view. Create FullName as a column expression in the named query.
• C.Implement a view in the database with FullName as a column expression. Replace DimCustomer with the view in the data source view.
• D.Implement a named calculation for FullName in the data source view.

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 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.
• 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 a line component between the report items for the Agency and State summary sections.

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 are the administrator of your company network. You use Server 2008 to develop a Business Intelligence (BI) solution. And you have deployed a SQL Server 2008 Reporting Services (SSRS) application. Users who use the SSRS application increase to a large number. Therefore, performance problems come into being. The datasets for the reports have been optimized. Now you check the SSRS deployment and find the following characteristics:There are plentiful graphical reports that summarize data.It is reported that the reports take a quite long time to run.The performance of reports that are run by interactive users is affected by Subscription processing. In order to solve the performance problems, you have to modify the SSRS infrastructure. So which scale-out strategy should you utilize?

• A.You should utilize single SSRS server and multiple reporting database servers
• B.You should utilize single SSRS server and a single reporting database server
• C.You should utilize multiple SSRS servers and a single reporting database server
• D.You should utilize multiple SSRS servers and multiple reporting database servers