Home » New Updated Microsoft MCSE 70-466 Real Exam Questions and Answers Download 51-60

New Updated Microsoft MCSE 70-466 Real Exam Questions and Answers Download 51-60

Ensurepass

QUESTION 51

You are developing a SQL Server Analysis Services (SSAS) tabular project. The model has tables named Invoice Line Items and Products.

 

The Invoice Line Items table has the following columns:

 

  • Product Id

  • Unit Sales Price

 

The Unit Sales Price column stores the unit price of the product sold.

 

The Products table has the following columns:

 

  • Product Id

  • Minimum Sales Price

 

The Minimum Sales Price column is available only in the Products table.

 

You add a column named Is Undersell to the Invoice Line Items table. The Is Undersell column must store a value of TRUE if the value of the Unit Sales Price is less than the value of the Minimum Sales Price. Otherwise, a value of FALSE must be stored. You need to define the Data Analysis Expressions (DAX) expression for the Is Undersell column. Which DAX formula should you use? (Each answer represents a complete solution. Choose all that apply.)

 

  1. =IF([Unit Sales Price] < RELATED(Products[Minimum Sales Price]), TRUE, FALSE)

  2. =IF(RELATED(Products[Unit Sales Price]) < [Minimum Sales Price], TRUE, FALSE)

  3. =IF([Unit Sales Price] < LOOKUPVALUE(Products[Minimum Sales Price], Products[Product Id], [Product Id]), TRUE, FALSE)

  4. =IF(LOOKUPVALUE(Products[Unit Sales Price], Products[Product Id], [Product Id]) < [Minimum Sales Price]), TRUE, FALSE)

Correct Answer: AC

 

 

QUESTION 52

You are developing a SQL Server Reporting Services (SSRS) report.

 

  • The report includes a dataset with fields named Year, MonthNumber, and InvCount.

  • The report includes a table that displays the inventory count per year, as shown in the following diagram.

 

You need to modify the table to include a graphical item displaying the inventory count trend to the right of the Inv Count column. What should you do?

 

  1. Add a text box to a new column on the right of the Inv Count column. Then use a Go to report action to link to a separate report showing the monthly trend.

  2. Add an Indicator item to a new column on the right of the Inv Count column. Select the Directional Indicator type and then select the MonthNumber field for Value.

  3. Add a Sparkline item to a new column on the right of the Inv Count column. Then select the InvCount field for Values and the MonthNumber field for Series Groups.

  4. Add a Sparkline item to a new column on the right of the Inv Count column. Then select the InvCount field for Values and the MonthNumber field for Category Groups.

  5. Add an Indicator item to a new colum
    n on the right of the Inv Count column. Select the Directional Indicator type and then assign the MonthNumber field to the Start property.

 

Correct Answer: D

 

 

QUESTION 53

You are developing a SQL Server Analysis Services (SSAS) multidimensional database. The underlying data source does not have a time dimension table. You need to implement a time dimension. What should you do?

 

  1. Create a time dimension by using the Define time intelligence option in the Business Intelligence Wizard.

  2. Use the SQL Server Data Tools Dimension Wizard and generate a time table in the data source.

  3. Create a time dimension by using the Define dimension intelligence option in the Business Intelligence Wizard.

  4. Add an existing SSAS database time dimension as a cube dimension.

 

Correct Answer: B

 

 

 

QUESTION 54

You are troubleshooting query performance for a SQL Server Analysis Services (SSAS) cube. A user reports that a Multidimensional Expressions (MDX) query is very slow. You need to identify the MDX query statement in a trace by using SQL Server Profiler. Which event class should you use?

 

  1. Query Begin

  2. Get Data From Aggregation

  3. Calculate Non Empty Begin

  4. Query Subcube

  5. Progress Report Begin

  6. Execute MDX Script Begin

 

Correct Answer: A

 

 

QUESTION 55

You are developing a SQL Server Analysis Services (SSAS) tabular project that will be used by the finance, sales, and marketing teams.

 

  • The sales team reports that the model is too complex and difficult to use.

  • The sales team does not need any information other than sales-related resources in the tabular model.

  • The finance and marketing teams need to see all the resources in the tabular model.

 

You need to implement a solution that meets the needs of the sales team while minimizing development and administrative effort. What should you do?

 

  1. Create a perspective for the sales team.

  2. Hide the non-sales columns from the client tools.

  3. Create a separate tabular model for each team.

  4. Create a security role for the sales team.

 

Correct Answer: A

 

 

QUESTION 56

You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A system role named Developer Support is present on the server. Members of the Developer Support role cannot modify the report execution timeout period. You need to enable members of the Developer Support role to modify the report execution timeout period. Which task should you add to the Developer Support role?

 

  1. Manage jobs

  2. Manage shared schedules

  3. Execute report definitions

  4. Manage report server properties

 

Correct Answer: D

 

 

QUESTION 57

You are developing a SQL Server Analysis Services (SSAS) cube. You are writing the following Multidimensional Expressions (MDX) statement for use by a calculated measure. The measure computes the sales amount for the same time period of the previous year. (Line numbers are included for reference only.)

 

01 CREATE MEMBER CURRENTCUBE.Measures.SamePeriodPreviousYearSales AS

02 (Measures.[Sales Amount],

03 ________________ (

04 [Date Order].[Calendar].[Calendar Year],

05 1,

06 [Date Order].[Calendar].CurrentMember)),

07 FORMAT_STRING = “#,#.00”;

 

You need to complete the MDX statement. Which MDX function should you use in line 03?

 

To answer, select the appropriate MDX function in the functions list.

 

70-466-demo-8

 

  1. CLOSINGPERIOD

  2. LASTPERIODS

  3. MTD

  4. OPENINGPERIOD

  5. PARALLELPERIOD

  6. PERIODSTODATE

  7. QTD

  8. WTD

  9. YTD

 

Correct Answer: E

 

 

QUESTION 58

You are creating a new report in SQL Server Report Builder. You add a SQL Azure data source. Then you add a dataset that has four fields named Year, Country, Category, and Sales. You must design a matrix as shown in the following diagram.

 

70-466-demo-9

 

The category rows (the first three rows as shown in the diagram) must present total sales amount by category. The country rows (the next six rows as shown in the diagram) must present total sales amount by country. The total row must present the total sales for each year. You add a matrix to the report. You add a grouping of the Category field on the rows and a grouping of the Year field on the columns. You need to add the countries on the rows of the matrix. Which Row Group option should you select when you add the group?

 

  1. Parent Group

  2. Child Group

  3. Adjacent Below

  4. Adjacent Above

 

Correct Answer: C

 

 

QUESTION 59

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?

 

  1. an Indicator

  2. a Data Bar

  3. a Sparkline

  4. a Gauge that uses the Radial type

  5. a Gauge that uses the Linear type

 

Correct Answer: A

 

 

QUESTION 60

You are developing a SQL Server Analysis Services (SSAS) tabular project. A model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations. The calculations are used to calculate the budget and forecast for the current quarter. You need to hide the tables and columns. What should you do?

 

  1. Before adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide option.

  2. Before adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide from Client Tools option.

  3. After adding the budget calculations to the model, in the Properties window for the applicable tables and columns, set the Enabled property to False.

  4. After adding the budget calculations to the model, in the Properties window for the applicable tables and columns, set the Visible property to True.

 

Correct Answer: B

 

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

Try Microsoft MCSE 70-466 Free Demo

HOT EXAM!
New Updated Microsoft MCSE 70-466 Real Exam Questions and Answers Download 61-70
New Updated Microsoft MCSE 70-466 Real Exam Questions and Answers Download 41-50

Name of author

Name: admin