Test4actual Help You Pass Any IT Exams

Posted By admin on September 20, 2010

Lots people failed the 70-452, because the 70-452 was changed, now the test4actual had update the newest 70-452 exam, so many people buy the 70-452 braindumps from test4actual, becasue our 70-452 are the real exam questions and have 100% correct answers! if you want to take 70-452, please choose test4actual, we are sure you will pass the exam with good score!

Still hesitant? See the DEMO first

 

1. You design a Business Intelligence (BI) solution by using SQL Server 2008.

You plan to create a SQL Server 2008 Reporting Services (SSRS) solution that contains five sales dashboard reports.

Users must be able to manipulate the reports’ parameters to analyze data.

You need to ensure that the following requirements are met:

��Users can manipulate the parameters for data analysis in a single trip to the data source.

��Reports are automatically rendered as soon as they are accessed for the first time.

Which two tasks should you perform? (Each correct answer presents part of the solution. Choose two.)

A. Filter data by using expressions.

B. Specify the default values for each parameter.

C. Create an available values list for each parameter.

D. Create report parameters by using query parameters to filter data at the data source.

Answer: AB

 

2. You design a SQL Server 2008 Reporting Services (SSRS) solution. You create a report by using Microsoft Visual Studio .NET 2008.

The report contains the following components:

��A dataset named Customer that lists all active customers and their details. The dataset accepts no parameters.

��A dataset named SalesHistory that lists all sales transactions for a specified time period and accepts year and month as parameters.

You need to ensure that a summary of sales transactions is displayed for each customer after the customer details.

Which component should you add to the report?

A. List

B. Table

C. Matrix

D. Subreport

Answer: D

 

3. You design a Business Intelligence (BI) solution by using SQL Server 2008.

The solution includes a SQL Server 2008 Analysis Services (SSAS) database. The database contains a data mining structure that uses a SQL Server 2008 table as a data source. A table named OrderDetails contains detailed information on product sales. The OrderDetails table includes a column named Markup.

You build a data mining model by using the Microsoft Decision Trees algorithm. You classify Markup as discretized content.

The algorithm produces a large number of branches for Markup and results in low confidence ratings on predictable columns.

You need to verify whether the Markup values include inaccurate data.

What should you do?

A. Modify the content type of Markup as Continuous.

B. Create a data mining dimension in the SSAS database from OrderDetails.

C. Create a data profile by using SQL Server 2008 Integration Services (SSIS).

D. .Create a cube in SSAS. Use OrderDetails as a measure group. Recreate the data mining structure and mining model from the cube data.

Answer: C

 

4. You design a Business Intelligence (BI) solution by using SQL Server 2008.

The solution contains a SQL Server 2008 Analysis Services (SSAS) database. A measure group in the database contains log entries of manufacturing events. These events include accidents, machine failures, production capacity metrics, and other activities.

You need to implement a data mining model that meets the following requirements:

��Predict the frequency of different event types.

��Identify short-term and long-term patterns.

Which algorithm should the data mining model use?

A. the Microsoft Time Series algorithm

B. the Microsoft Decision Trees algorithm

C. the Microsoft Linear Regression algorithm

D. the Microsoft Logistic Regression algorithm

Answer: A

 

5. You design a Business Intelligence (BI) solution by using SQL Server 2008.

The solution includes a SQL Server 2008 Analysis Services (SSAS) database. A cube in the database contains a large dimension named Customers. The database uses a data source that is located on a remote server.

Each day, an application adds millions of fact rows and thousands of new customers.

Currently, a full process of the cube takes several hours.

You need to ensure that queries return the most recent customer data with the minimum amount of latency.

Which cube storage model should you use?

A. hybrid online analytical processing (HOLAP)

B. relational online analytical processing (ROLAP)

C. multidimensional online analytical processing (MOLAP)

D. automatic multidimensional online analytical processing (automatic MOLAP)

Answer: A

Categories: Microsoft
Tags: 70-452