New Updated Microsoft MCSE 70-466 Real Exam Questions and Answers Download 131-140

Ensurepass

QUESTION 131

You are conducting a design review of a multidimensional project. In the Customer Geography dimension, all non-key attributes relate directly to the key attribute. The underlying data of the Customer Geography dimension supports relationships between attributes. You need to increase query and dimension processing performance. What should you do?

 

A.

For the dimension attributes of the Customer Geography dimension, define appropriate attribute relationships.

B.

For the dimension attributes of the Customer Geography dimension, set the GroupingBehavior property to EncourageGrouping.

C.

For the Customer Geography dimension, set the Processing Mode property to LazyAggregations.

D.

For the Customer Geography dimension, set the ProcessingPriority property to 1.

 

Correct Answer: A

 

 

QUESTION 132

You are modifying a SQL Server Analysis Services (SSAS) cube that aggregates order data from a Microsoft Azure SQL Database database. The existing database contains a customer dimension.

 

The marketing team has requested that customer marketing categories be added to the database.

 

The marketing categories must meet the following requirements:

 

clip_image002A customer member must be able to belong to multiple category members.

clip_image002[1]A category member must be able to group several customer members.

clip_image002[2]The marketing team must be able to create new categories every month in the data source.

 

You need to implement the appropriate solution to meet the requirements while ensuring that the amount of development and maintenance time is minimized.

 

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

A.

Create a dimension named Marketing Category Name and then configure a many-to- many relationship.

B.

Create a dimension named Marketing Category Name and then configure a regular relationship.

C.

Add an attribute hierarchy named Marketing Category Name to the customer dimension.

D.

Add an attribute hierarchy for each marketing category to the customer dimension. Configure each hierarchy to have two members named Yes and No.

 

Correct Answer: D

 

 

QUESTION 133

DRAG DROP

You are making changes to a cube named Sales. You must increase the value of the measure named Sales Amount by 10%. The increase must be applied only to the children of the member named East in the dimension named Customer. You need to complete the Multidimensional Expressions (MDX) statement in the calculations section of the Sales cube. Which statement fragments should you use? (To answer, drag the appropriate statement component to the correct location or locations in the answer area. Use only components that apply.)

 

clip_image004

 

Correct Answer:

clip_image006

 

 

QUESTION 134

HOTSPOT

You are designing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database. You need to design the report to show the sum of sales. The sales must be grouped by region on the rows and year on the columns. Which report item should you add? To answer, select the appropriate setting in the answer area.

 

clip_image008

 

Correct Answer:

clip_image010

QUESTION 135

You are working with a SQL Server Reporting Services (SSRS) instance in native mode. An item role named Developer is present on the server. The Developer role cannot view and modify report caching parameters. You need to ensure that the Developer role can view and modify report caching parameters. Which task should you add to the Developer role?

 

A.

Manage individual subscriptions

B.

View data sources

C.

Manage report history

D.

Manage all subscriptions

 

Correct Answer: C

 

 

QUESTION 136

You manage a SQL Server Reporting Services (SSRS) instance. The ReportingServicesService.exe.config file has been modified to enable logging. Some users report that they cannot access the server. You need to ascertain the IP addresses of the client computers that are accessing the server. What should you do?

 

A.

View the ExecutionLog view in the Report Server database.

B.

View the Report Server service trace log.

C.

View the Report Server HTTP log.

D.

View the Windows System event log.

 

Correct Answer: C

Explanation:

http://msdn.microsoft.com/en-us/library/bb630443.aspx

 

 

QUESTION 137

A multinational retailer has retail locations on several continents. A single SQL Server Reporting Services (SSRS) instance is used for global reporting.

 

A SQL Server Analysis Services (SSAS) instance for each continent hosts a multidimensional database named RetailSales. Each RetailSales database stores data only for the continent in which it resides. All of the SSAS instances are configured identically.

The cube names and objects are identical.

 

Reports must meet the following requirements:

 

clip_image002[3]A report parameter named ServerName must be defined in each report.

clip_image002[4]When running a report, users must be prompted to select a server instance.

clip_image002[5]The report data source must use the Microsoft SQL Server Analysis Services data source type.

 

You need to create a data source to meet the requirements.

 

How should you define the expression that is assigned to the connection string property of the data source?

 

A.

=”Server=” & ParametersIServerName.Value & “; Initial Catalog=RetailSales”

B.

=”Data Source=@ServerName; Initial Catalog=RetailSales”

C.

=”Data Source=” & Parameters!ServerName.Value & “;Initial Catalog=RetailSales”

D.

=”Server=” & Parameters!ServerName.Value

E.

=”Server=@ServerName; Initial Catalog=RetailSales”

 

Correct Answer: C

 

 

QUESTION 138

You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSAS) cube. The cube is used to measure sales growth by salesperson. The cube contains a Key Performance Indicator (KPI) to show if a salesperson’s sales are off target slightly off target, or on target. You need to add a report item that visually displays the KPI status value as a red, yellow, or green flag. Which report item should you add?

 

A.

An Indicator

B.

A Gauge that uses the Radial type

C.

A Gauge that uses the Linear type

D.

A Sparkline

E.

A Data Bar

 

Correct Answer: A

 

 

QUESTION 139

HOTSPOT

You create a new report in SQL Server Data Tools (SSDT). The report queries a Microsoft Azure SQL Database database table. In a report table showing sales by cities, you need to enable users to interactively drill through to another report to show details of the customer sales within a chosen city. Which text box property page should you use? (To answer, select the appropriate tab in the answer area.)

 

clip_image011

 

Correct Answer:

clip_image012

 

 

QUESTION 140

You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML. The report includes a dataset with fields named Description. Price, and Color. The report layout includes a table that displays product details and also includes columns named Description, Price, and Color. You need to modify the report so that users can sort products by the Price column. What should you do?

 

A.

Set the SortExpression value to = Fields!Price.Description for the Price text box.

B.

Set the SortExpression property to =Fields!Price.Name for the Price text box.

C.

Set the SortExpression property to =Fields!Price.Value for the Price text box.

D.

Add a custom action to the Price text box.

 

Correct Answer: C

 

Instant Access to Download Latest Complete Collection of Microsoft MCSE 70-466 Real Exam

Try Microsoft MCSE 70-466 Free Demo