Online Access Free 070-466 Exam Questions

You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant the minimum permissions necessary to enable users to query data in a data model.
Which role permission should you use?

• A.Browser
• B.Administrator
• C.Select
• D.Explorer
• E.Process
• F.Read

DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to add a calculated column to a table in the model.
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:
* In the model designer, in Data View, select the table to which you want to add a calculated column, then click the Column menu, and then click Add Column.
* To create a new calculated columnAdd Column is highlighted over the empty rightmost column, and the cursor moves to the formula bar.
To create a new column between two existing columns, right-click an existing column, and then click Insert Column.
* In the formula bar, do one of the following:
* Press ENTER to accept the formula.
* Calculated columns, in tabular models, allow you to add new data to your model. Instead of pasting or importing values into the column, you create a DAX formula that defines the column's row level values. The calculated column can then be used in a report, PivotTable, or PivotChart as would any other column.
* A calculated column is DAX expression that creates a new column in a table and the obtained values are stored in the table; the calculated column expression is evaluated every time the table is processed.
* In tabular object models the calculated column is a column in a table whose values are calculated upon definition of the column, from an expression.

HOTSPOT
You maintain a multidimensional Business Intelligence Semantic Model (BISM) that was developed with default settings.
The model has one cube and the cube has one measure group. The measure group is based on a very large fact table and is partitioned by month. The fact table is incrementally loaded each day with approximately 800,000 new rows.
You need to ensure that all rows are available in the cube while minimizing the processing time.
Which processing option should you use? (To answer, select the appropriate option in the answer area.)

Correct Answer:

Explanation:
Process Add

You need to create a measure for DOD sales.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

• A.Specify a date table by using a Mark the Date table.
• B.Create a date dimension by using the Dimension wizard with a date template.
• C.Use the Multidimensional Expressions (MDX) PARALLELPERIOD( ) function.
• D.Use the Data Analysis Expressions (DAX) PARALLELPERIOD ( ) function.

You are creating a SQL Server Analysis Services (SSAS) multidimensional database.
Users need a time dimension for:
* Dates
* Delivery dates
* Ship dates
You need to implement the minimum number of required SSAS objects.
What should you do?

• A.Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.
• B.Create a dimension. Then add a cube dimension and link it several times to the measure group.
• C.Add a measure that uses the Count aggregate function to an existing measure group.
• D.Create a new named calculation in the data source view to calculate a rolling sum. Add a measure that uses the Max aggregate function based on the named calculation.
• E.Use the Business Intelligence Wizard to define dimension intelligence.
• F.Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
• G.Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
• H.Add a measure group that has one measure that uses the DistinctCount aggregate function.
• I.Create a dimension with one attribute hierarchy. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember property. Configure the cube dimension so that it does not have a relationship with the measure group. Add a calculated measure that uses the MemberValue attribute property.
• J.Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
• K.Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a regular relationship between the dimension and measure group.
• L.Use role playing dimensions.
• M.Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
• N.Create several dimensions. Add each dimension to the cube.
• O.Add a measure that uses the DistinctCount aggregate function to an existing measure group.