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

Ensurepass

QUESTION 51

DRAG DROP

You are developing a SQL Server Analysis Services (SSAS) tabular project based on a Microsoft Azure SQL Database database. The ProcessingOption property for the project is set to Do Not Process.

 

Several calculated columns have been added to a table. The project has been deployed to the production server.

 

You need to ensure that newly added data is processed on the production server.

 

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_image002

 

Correct Answer:

clip_image004

 

 

QUESTION 52

HOTSPOT

A SQL Server Analysis Services (SSAS) cube has roles to define dimension data security. A role named USA allows users to browse data pertaining to the United States. A role named Canada allows users to browse data pertaining to Canada.

 

A user can browse sales data pertaining to the United States but cannot browse sales data pertaining to Canada. You validate that the user belongs to the USA and Canada roles.

 

You need to reproduce the issue in SQL Server Management Studio (SSMS).

 

Which option should you select? To answer, select the appropriate action in the answer area.

 

clip_image005

 

Correct Answer:

clip_image006

 

 

QUESTION 53

You manage an environment that has SharePoint Server 2010 and a SQL Server Reporting Services (SSRS) instance in SharePoint integrated mode. Several report subscriptions are configured to deliver reports through email by using a shared schedule. The email server will be going offline. You need to temporarily suspend the shared schedule until the email server is brought back online. What should you do?

 

A.

In Report Manager, pause the shared schedule.

B.

In SharePoint Central Administration, pause the shared schedule.

C.

In Report Manager, delete the shared schedule.

D.

In SharePoint Central Administration, delete the shared schedule.

 

Correct Answer: B

 

 

QUESTION 54

DRAG DROP

You manage a SQL Server Reporting Services (SSRS) instance in native mode. You are building a shared dataset for your weekly performance reports. The shared dataset uses a data source that is configured to use credentials that are stored in the Report Server.

 

You have a predefined shared schedule to perform cleanup and maintenance tasks for SSRS.

 

You need to enable caching on the shared dataset. You also need to use an existing shared schedule to discard the cache.

 

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_image008

 

Correct Answer:

clip_image010

 

 

QUESTION 55

You are designing a SQL Server Reporting Services (SSRS) report for a bank. The bank has Automated Teller Machines (ATMs) in several regions. ATM operational data is stored in a Microsoft Azure SQL Database database.

 

The report must use a map to display the location and status of the ATMs as shown in the following exhibit. (Click the Exhibit button.)

 

clip_image012

 

You need to ensure that the report displays only a user selected map region.

 

Which source of spatial data should you use for the map?

 

A.

SQL Server spatial query

B.

Map gallery

C.

ESRI shape file

D.

Bing Maps layer

 

Correct Answer: A

 

 

QUESTION 56

You are developing a SQL Server Reporting Services (SSRS) report. The report includes a dataset with fields namedYear Month Number, and InvCount. The report includes a table that displays the inventory count per year, as shown in the followingtable.

 

clip_image013

 

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?

 

A.

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

B.

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.

C.

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.

D.

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.

E.

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

 

Correct Answer: C

 

 

QUESTION 57

You are developing a SQL Server Reporting Services (SSRS) report for a company that has a subscription to a dataset from the Microsoft Azure Data Market. The dataset permits flexible queries. You need to choose the connection type for the data source. Which connection type should you choose?

 

A.

XML

B.

Microsoft Azure SQL Database

C.

Microsoft SharePoint List

D.

ODBC

 

Correct Answer: A

 

QUESTION 58

You are designing a SQL Server Reporting Services (SSRS) report. The report defines a single SQL Server data source and dataset. You need to include additional data sourced from a Microsoft Azure SQL Database database in the report. What should you do?

 

A.

Create a SQL Server data source and then add a dataset that uses the new data source.

B.

Create a Microsoft Azure SQL Database data source and then add a dataset that uses the new data source.

C.

Generate an Atom-compliant data feed for the report.

D.

Create a Microsoft Azure SQL Database dataset that uses the existing data source.

 

Correct Answer: C

 

 

QUESTION 59

You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT). This report has a table named Table1 and a textbox named Textbox1. Table1 is initially visible but the user must be able to choose when to hide it. You need to develop the report to meet the requirement. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

A.

For the properties of Table1, configure the Display can be toggled by this report item option to use Textbox1.

B.

Configure Textbox1 to drill through to rerun the report to toggle the display of Table1.

C.

For the properties of Table1, configure the Display can be toggled by this report item option to use Table1

D.

Add a parameter to the report so users can choose the display state of Table1.

 

Correct Answer: A

 

 

QUESTION 60

You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT). The report must define a report parameter to prompt the user for the business unit. Each business unit has a unique font scheme combination of font and size properties. You need to ensure that all of the text boxes in the table headers use the correct business unit font properties. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

A.

Add one report variable for FontFamily Assign it with an expression to return the appropriate colors. For each header text box, set the Color and FontSize properties by

using the variables.

B.

For each header text box, assign expressions to the FontFamily and FontSize properties.

C.

Add two report variables named FontFamily and FontSize. Assign them with expressions to return the appropriate colors. For each header text box, use expressions to set the FontFamily and FontSize properties by using the variables.

D.

Add two Microsoft Visual C# functions to the code block of the report to implement FontFamily and FontSize functions. For each header text box, use expressions to set the FontFamily and FontSize properties by using the functions.

 

Correct Answer: D

 

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

Try Microsoft MCSE 70-466 Free Demo