Home » [Free] Get all latest Microsoft 70-466 Actual Tests 161-170

[Free] Get all latest Microsoft 70-466 Actual Tests 161-170

Ensurepass

QUESTION 161

HOTSPOT

A sales cube contains two years of data. The sales team must see year-over-year (YOY) and month-over-month (MOM) sales metrics. You need to modify the cube to support the sales team’s requirements. Which Business Intelligence Wizard enhancements should you use? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

 

clip_image001

 

Correct Answer:

clip_image002

QUESTION 162

You are developing a SQL Server Analysis Services (SSAS) tabular project. A model defines a measure named Profit and includes a table named Date. The table includes year, semester, quarter, month, and date columns. The Date column is of data type Date. The table contains a set of contiguous dates. You need to create a measure to report on year-over-year growth of profit.

What should you do? (Each answer presents a complete solution. Choose all that apply.)

 

clip_image004

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

Correct Answer: CD

 

 

QUESTION 163

You are developing a SQL Server Analysis Services (SSAS) tabular project. You need to grant permission for salespersons to be able to view only the data based on their sales territory. What should you do?

 

A.

Create a member and then create a Multidimensional Expressions (MDX) filter.

B.

Create a member and then create a Data Analysis Expressions (DAX) filter.

C.

Create a role and then create a Multidimensional Expressions (MDX) filter.

D.

Create a role and then create a Data Analysis Expressions (DAX) filter.

 

Correct Answer: C

 

 

QUESTION 164

You deploy a tabular model in DirectQuery mode to a server named Server1. Server1 has SQL Server Analysis Services (SSAS) installed. The model uses a relational data source named DB1.

You need to ensure that Server1 passes the credentials of the current user browsing the model to DB1. What should you do?

 

A.

Register a Service Principal Name (SPN) for Server1.

B.

From the SQL Server Data Tools, modify the impersonation settings.

C.

From the Web.config file, modify the impersonation settings.

D.

Register a Service Principal Name (SPN) for DB1.

 

Correct Answer: A

 

QUESTION 165

DRAG DROP

You are developing a SQL Server Reporting Services (SSRS) report to display a list of employees. The report will be embedded into a Microsoft SharePoint Server Web Part Page of the company intranet site.

 

The report consists of a single table. The design of the table is shown in the following diagram.

 

clip_image005

 

You need to configure the EmailAddress detail text box to create a new email message. The email message must be addressed to the email address that was clicked by the user.

 

Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

 

clip_image007

 

Correct Answer:

clip_image009

 

 

 

 

 

QUESTION 166

HOTSPOT

You create a new report in SQL Server Data Tools (SSDT). The report queries a Windows Azure SQL Database database table. In a report table showing sales by countries and cities, you need to enable users to hide or show cities by clicking the name of a country. Which property page of the city text box should you use? (To answer, select the appropriate tab in the answer area.)

 

clip_image010

 

Correct Answer:

clip_image011

 

 

QUESTION 167

You are developing a SQL Server Reporting Services (SSRS) report. The report includes a dataset with fields named.

 

Year MonthNumber, and RegCount. The report includes a table that displays the number of recorded registration occurrences per year,as shown in the following table.

 

clip_image012

 

You need to modify the table to include a graphical item displaying the monthly registration trend to the right of the Reg Count column.

 

What should you do?

 

A.

Add an Indicator item to a new column on the right of the Reg Count column. Select the Directional Indicator Type and then assign the MonthNumber field to the Start property.

B.

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

C.

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

D.

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

E.

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

 

Correct Answer: E

 

 

QUESTION 168

You manage a SQL Server Reporting Services (SSRS) instance. An application must pass credentials to the local security authority for Reporting Services. You need to configure Reporting Services to issue a challenge/response when a connection is made without credentials. Which authentication type should you configure in the RSReportServer.config file?

 

A.

RSWindowsKerberos

B.

RSWindowsNegotiate

C.

RSWindowsNTLM

D.

RSWindowsBasic

 

Correct Answer: A

 

 

QUESTION 169

You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSASJ cube. 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 circle. Which report item should you add?

 

A.

Linear Gauge

B.

Indicator

C.

Data Bar

D.

Radial Gauge

E.

Sparkline

 

Correct Answer: B

 

 

QUESTION 170

DRAG DROP

You manage a SQL Server Reporting Services (SSRS) instance running in native mode. You are troubleshooting a performance problem and need to know which reports are frequently executed. You discover that the report server execution logs are empty, despite significant report activity. You need to ensure that the server is configured for report execution logging. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

 

clip_image014

 

Correct Answer:

clip_image016

 

Instant Access to Download Testing Software & PDF File for Microsoft 70-466 Real Exam

Instant Access to Try Microsoft 70-466 Free Demo

HOT EXAM!

Name of author

Name: admin