Free Microsoft 70-466 Exam Dumps Questions & Answers

DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) multidimensional project. The project file includes two cubes named Finance and Operations. The project also includes a dimension named Date. The Date dimension includes two hierarchies named Fiscal and Calendar. The Date dimension has been added to both cubes.
You need to disable the Fiscal hierarchy in the Operations cube without impacting other database objects.
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:

Explanation:
Box 1:

Box 2:

Box 3:

Note:
* The value of the AttributeHierarchyEnabled property determines whether an attribute hierarchy is created. If this property is set toFalse, the attribute hierarchy is not created and the attribute cannot be used as a level in a user hierarchy; the attribute hierarchy exists as a member property only. However, a disabled attribute hierarchy can still be used to order the members of another attribute. If the value of the AttributeHierarchyEnabled property is set toTrue, the value of the AttributeHierarchyVisible property determines whether the attribute hierarchy is visible independent of its use in a user-defined hierarchy.
* To set the attribute hierarchy properties in the Employee dimension
* Switch to Dimension Designer for the Employee dimension, and then click the Browser tab.
* Verify that the following attribute hierarchies appear in the Hierarchy list:
* Switch to the Dimension Structure tab, and then select the following attributes in the Attributes pane, by using the CTRL key to select multiple attributes at the same time:
* In the Properties window, set the value of the AttributeHierarchyEnabled property to False for the selected attributes.
Etc.

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.  When the report is initially run, select Hide.
• B.  When the report is initially run, select Show or hide based on an expression. Set the expression to = (Globals!RenderFormat.IsInteractive)
• C.  When the report is initially run, select Show or hide based on an expression. Set the expression to =NOT (Globals!RenderFormat.IsInteractive).
• D.  When the report is initially run, select Show.

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:

Explanation:
Box 1:

Box 2:

Box 3:

Note:
* you can use the Linked Object Wizard to add a measure group from another database
* You can use the Linked Object Wizard to either link to or import cubes, dimensions, measure groups, calculations, and Key Performance Indicators (KPIs). You can link to or import these items from another database on the same server or from a database on a remote server
* The Linked Object Wizard guides you through the following steps:
Selecting the Analysis Services data source from which to link or import objects.
Selecting the objects from which to link or import.
Saving the changes.
Create or modify a linked measureUse SQL Server Data Tools to create a linked measure group.
* Finalize any modifications to the original measure group now, in the source cube, so that you don't have to recreate the linked measure groups later in subsequent cubes. You can rename a linked object, but you cannot change any other properties.
* In Solution Explorer, double-click the cube to which you are adding the linked measure group. This step opens the cube in Cube Designer.
* In Cube Designer, in either the Measures pane or Dimensions pane, right-click anywhere in either pane, then select New Linked Object. This starts the Linked Object Wizard.
* On the first page, specify the data source. This step establishes the location of the original measure group. The default is the current cube in the current database, but you can also choose a different Analysis Services database.
* On the next page, choose the measure group or dimension you want to link.
Dimensions and Cube objects, such as measure groups, are listed separately.
Only those objects not already present in the current cube are available.
* Click Finish to create the linked object. Linked objects appear in the Measures and Dimensions pane, indicated by the link icon.
Ref: http://msdn.microsoft.com/en-us/library/ms174899(v=sql.110).aspx

You need to configure SSRS to meet the maximum number of snapshots requirement.
What should you do? (Each answer presents a complete solution. Choose all that apply.)

• A.  Use PowerShell to set the System Snapshot Limit option to 5.
• B.  In Reporting Services Configuration Manager, set the Limit number of snapshots option to 5.
• C.  In SharePoint Central Administration, set the System Snapshot Limit option to 5.
• D.  For each report, set the System Snapshot Limit option to 5.

You need to modify the Sales cube to support the planning requirements.
Which SSAS feature should you use?

• A.  A KPI
• B.  A perspective
• C.  A writeback partition
• D.  A translation