Online Access Free 070-466 Exam Questions

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations. The calculations are used to calculate the budget and forecast for the current quarter.
You need to hide the tables and columns.
What should you do?

• A.After adding the budget calculations to the model, in the Properties window for the applicable tables and columns, set the Visible property to True.
• B.After adding the budget calculations to the model, in the Properties window for the applicable tables and columns, set the Enabled property to False.
• C.Before adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide from Client Tools option.
• D.Before adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide option.

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations.
You need to hide the tables and columns.
What should you do?

• A.In the Properties window for the applicable tables and columns, set the Enabled property to False.
• B.In the Properties window for the applicable tables and columns, set the Visible property to True.
• C.Right-click the applicable tables and columns and select the Hide option.
• D.Right-click the applicable tables and columns and select the Hide from Client Tools option.

A production SQL Server Analysis Services (SSAS) cube is processed daily. The users query products by using a hierarchy named Products from a dimension named Product.
The DimProduct table in the data source view is used as the source of the Product dimension. The table has the following structure.

The Product dimension has three attribute hierarchies:
* Product
* Subcategory
* Category
The attributes have the following relationships defined: Product > Subcategory > Category.
Each attribute has a key and a name sourced from the related key and name columns in the DimProduct table.
During processing, you receive the following error message: 'Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table:
'dbo_DimProduct', Column: 'SubCategoryKey1, Value: "23'. The attribute is Subcategory'." You verify that the data is accurate.
You need to ensure that the dimension processes successfully.
What should you do?

• A.Remove the duplicate data from the DimProduct table.
• B.Remove the Subcategory attribute.
• C.Delete the Products hierarchy.
• D.Relate the Subcategory and Category attributes directly to the Product attribute.

You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLAP partitions.
You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis.
What should you do before the partition can be write-enabled?

• A.Set the StorageMode property of the linked measure group to Rolap.
• B.Set the Type property of the partition's measure group to Forecast.
• C.Implement the linked measure group as a local measure group.
• D.Implement the local measure group as a linked measure group.

HOTSPOT
You create a new report in SQL Server Data Tools (SSDT). The report queries a Microsoft Azure SQL Database database table.
In a report table showing sales by cities, you need to enable users to interactively drill through to another report to show details of the customer sales within a chosen city.
Which text box property page should you use? (To answer, select the appropriate tab in the answer area.)

Correct Answer: