Free Microsoft 70-460 Exam Dumps Questions & Answers

DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to reuse a Revenue measure group from a different database.
In SQL Server Data Tools (SSDT), 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.)

Correct Answer:

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.

Correct Answer:

You need to configure the Scenario attribute to ensure that business users appropriately query the Sales Plan measure.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

• A.  Set the RootMemberIf property to ParentIsMissing.
• B.  set the DefaultMember property to the Forecast member.
• C.  Set the AttributeHierarchyVisible property to False.
• D.  Set the AttributeHierarchyEnabled property to False.
• E.  Set the IsAggregatable property to False.
• F.  Set the Usage property to Parent.

You are modifying a star schema data mart that feeds order data from a Microsoft Azure SQL Database database into a SQL Server Analysis Services (SSAS) cube. The data mart contains two large tables that include flags and indicators for some orders. There are 100 different flag columns, each with 10 different indicator values. Some flags reuse indicators. The tables both have a granularity that matches the fact table.
You have the following requirements:
- Allow users to slice data by all flags and indicators. - Modify the date dimension table to include a surrogate key of a numeric data type and add the surrogate key to the fact table. - Use the most efficient design strategy for cube processing and queries.
You need to modify the schema.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.  Define the surrogate key as a BIGINT data type. Combine the distinct flag/indicator combinations into a single dimension.
• B.  Define the surrogate key as an INT data type. Create a single fact dimension in each table for its flags and indicators.
• C.  Define the surrogate key as a BIGINT data type. Create a single fact dimension in each table for its flags and indicators.
• D.  Define the surrogate key as an INT data type. Combine the distinct flag/indicator combinations into a single dimension.

You need to re-establish subscriptions on SSRS01.
What should you do?

• A.  Generate a SQL Server 2012 configuration file by running the SQL Server Setup executable.
• B.  Install prerequisites and upgrade shared components on Node1 and Node2.
• C.  Manually failover the active node.
• D.  Upgrade Node1 by using the SQL Server 2012 Upgrade Wizard.