Exit demo 70-460 Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence PDF format · free preview

Microsoft 70-460 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/70-460.html

Question 1
Single choice

You need to configure a hierarchy for DimProduct that meets the technical requirements.

What should you do?

A.

Set ProductCategory as the parent of ProductSubcategory and set ProductSubCategory as the parent of ProductName. For ProductCategory, click Hide if Name Equals Parent

B.

Set ProductCategory as the parent of ProductSubCategory and set ProductSubcategory as the parent of ProductName. For ProductSubcategory, click Hide if Name Equals Parent.

C.

Set ProductName as the parent of ProductSubcategory and set ProductSubCategory as the parent of ProductCategory. For ProductCategory, click Hide if Name Equals Parent

D.

Set ProductName as the parent of ProductSubCategory and set ProductSubcategory as the parent of ProductCategory. For ProductSubcategory, click Hide if Name Equals Parent.

Question 2
Single choice

After you deploy the RegionalSales report, you attempt to configure the subscriptions.

You discover that the subscription creation screen does not display the option to deliver the report by email.

You need to ensure that subscriptions can be delivered by using email.

What should you do?

A.

From Central Administration, modify the properties of the Reporting Service Application.

B.

Modify the Rssrvrpolicy.config file.

C.

Modify the Rsmgrpolicy.config file.

D.

From Central Administration, modify the SMTP settings of the SharePoint Server server farm.

Question 3
Single choice

After you deploy the RegionalSales report, users report that they cannot see product data when they receive the reports by email.
You need to ensure that the sales department managers can see all of the data.

In the report, you update the Hidden property of each group.

What should you do next?

A.

In When the report is initially run, select Show or hide based on an expression. Set the expression to = (GlobalsIRenderFormaUsInteractive).

B.

In When the report is initially run, select Show or hide based on an expression. Se: The expression to
=NOT (GlobalslRenderFormat.IsInteractive)

C.

In when the report is initially run, select Show.

D.

In When the report is initially run, select Hide.

Question 4
Single choice

You need to recommend a solution for the sales department that meets the security requirements.

What should you recommend?

A.

Create one role for all of the sales department users. Configure the role to have read access to the sales transactions. Ensure that all of the reports that access the sales transaction data restrict read access to the data from the corresponding sales department region only.

B.

Create one role for each region. Configure each role to have read access to a specific region.
Add the sales department users to their corresponding role.

C.

Create one role for all of the sales department users. Add a DAX filter that reads the current user name and retrieves the user's region.

D.

Create a table for each region. Create a role for each region. Grant each role read access to its corresponding table.

Question 5
Single choice

You need to ensure that all reports meet the reporting requirements.

What is the best way to achieve the goal? More than one answer choice may achieve the goal.
Select the BEST answer.

A.

Create a report part. Publish the report part to a server that has SSRS installed. Add the report part to each new report that is created.

B.

Create a report part. Publish the report part to a SharePoint site. Add the report part to each new report that is created.

C.

Create a report. Copy the report to source code control. Create each new report by using the report template in source code control.

D.

Create a report. Copy the report to the PrivateAssemblies\ProjectItems\ReportProject folder in the Visual Studio directory. Create each new report by using the locally stored report

Question 6
Multiple choice

You execute the SalesbyCategory report and receive the following error message: "Members, types, or sets must use the same hierarchies in the function."

You need to ensure that the query executes successfully.

Which two actions should you perform? Each correct answer presents part of the solution.

A.

Move the Date and Product clauses on line 11 to axis

B.

Move the Date clause from line 10 to line 08.

C.

Move the Measures clause on line 02 to axis 1.

D.

Move the Product clause from line 08 to line 10.

Question 7
Single choice

You are deploying the Research model.

You need to ensure that the data contained in the model can be refreshed.

What should you do?

A.

Upload MarketResearch.xIsx to Library1.

B.

Create a SQL Server Integration Services (SSIS) package that imports data from MarketResearch.xIsx nightly. Load the data to CUBE1,

C.

Import MarketResearch.xIsx to a new tabular database on the Tabular instance.

D.

Assign the Tabular instance service account permissions to the MarketResearch.xlsx network location.

Question 8
Single choice

You need to configure Library1 to support the planned self-service reports.

What is the best configuration you should add to Library1? More than one answer choice may achieve the goal. Select the BEST answer.

A.

the Report Builder Model content type

B.

the PowerPivot Gallery Document content type

C.

the Report Builder report content type

D.

the Report content type

Question 9
Drag & drop

DRAG DROP

You need to recommend a solution to implement the data security requirements for CUBE1.

Which three actions should you recommend performing in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Question 10
Single choice

You need to design a cube partitioning strategy to be implemented as the cube size increases.

What should you do?

A.

Implement monthly remote partitions.

B.

Implement monthly local partitions.

C.

Use multidimensional OLAP (MOLAP) on all local partitions.

D.

Use relational OLAP (ROLAP) on all local partitions.

Showing 10 of 82 questions · Unlock the full set