QUESTION 61
Drag and Drop Questions
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.)
Explanation:
* 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.
* Use the Select Objects page to select the objects that will be linked to or imported. Dimensions and measure groups (including the associated measures) are linked. Actions, key performance indicators (KPIs), and calculations are imported.
QUESTION 62
Drag and Drop Questions
You are developing reports based on the SQL Server Analysis Services (SSAS) cube named ProcessedOrders. A Multidimensional Expressions (MDX) query must include a query-scoped calculated member, which computes average sales per order item. The query must also return the set of three states in a query-scoped named set named East Coast Customers. You need to define the calculations in an MDX query to meet the requirements. Which four MDX segments should you insert in sequence before a SELECT statement? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Explanation:
* Example:
SELECT
{ [Measures].[Sales Amount],
[Measures].[Tax Amount] } ON COLUMNS,
{ [Date].[Fiscal].[Fiscal Year].&[2002],
[Date].[Fiscal].[Fiscal Year].&[2003] } ON ROWS
FROM [Adventure Works]
WHERE ( [Sales Territory].[Southwest] )
QUESTION 63
You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financial database. The model will be deployed to a server with 28 GB of RAM. The source data, located in a SQL Server data warehouse, is currently using 15 terabytes of disk space and is doubling in size every month. The model will be queried by staff in the accounting department by using Microsoft Excel 2010. You need to ensure the highest query performance and scalability for the accounting department queries. Which project type should you choose?
A. tabular project that uses the In-Memory query mode
B. tabular project that uses the DirectQuery query mode
C. multidimensional project
D. PowerPivot workbook deployed to SharePoint
Answer: C
QUESTION 64
You are developing a BI Semantic Model (BISM) that retrieves data from several sources including a SQL Azure database and an OData data feed. The model will be deployed to a server with significantly more memory than the total size of the source data. You have the data feed URL, which you will use when developing the model in SQL Server Data Tools (SSDT). The model must meet the following requirements:
Maximize performance
Data latency of up to one month is acceptable
You need to choose a project type and a data access mode to meet the requirements.
What should you do?
A. Select the tabular project type and use the In-Memory query mode.
B. Select the multidimensional project type and use the MOLAP storage mode.
C. Select the tabular project type and use the DirectQuery query mode.
D. Select the multidimensional project type and use the ROLAP storage mode.
Answer: A
QUESTION 65
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. Implement the linked measure group as a local measure group.
B. Implement the local measure group as a linked measure group.
C. Set the Type property of the partition’s measure group to Forecast.
D. Set the StorageMode property of the linked measure group to Rolap.
Answer: A
QUESTION 66
Hotspot Question
You are developing a SQL Server Analysis Services (SSAS) cube. You are writing the following Multidimensional Expressions (MDX) statement for use by a calculated measure. The measure computes the sales amount for the same time period of the previous year. (Line numbers are included for reference only.)
You need to complete the MDX statement. Which MDX function should you use in line 03? To answer, select the appropriate MDX function in the functions list.
QUESTION 67
Drag and Drop Questions
You are developing a SQL Server Analysis Services (S5AS) cube. You need to add a calculated member to the Customer dimension to evaluate the sum of values for France and Germany. Which expression should you use? (To answer, drag the appropriate expression to the answer area.)
Explanation:
* Calculated members are members of a dimension or a measure group that are defined based on a combination of cube data, arithmetic operators, numbers, and functions. For example, you can create a calculated member that calculates the sum of two physical measures in the cube. Calculated member definitions are stored in cubes, but their values are calculated at query time.
* Measure values are generally summed, but may also be counted or aggregated in some other manner.
QUESTION 68
You are developing a SQL Server Analysis Services (SSAS) cube for the accounts department. You create a measure group named Exchange Rate that consists of measures pertaining to currency exchange rates. One of the measures in this group is named Average Rate and it will be used to report the average currency exchange rate over time. Currently the AggregationFunction property for the Average Rate measure is set to Sum.
You need to ensure that Average Rate measure reports the average of the currency exchange rate over time. Which value should you select for the AggregationFunction property for the Average Rate measure? To answer, select the appropriate setting in the answer area.
A. AverageOfChildren
B. ByAccount
C. Count
D. DistinctCount
E. FirstChild
F. FirstNonEmpty
G. LastChild
H. LastNonEmpty
I. Max
J. Min
K. None
L. Sum
Answer: A
Explanation:
AverageOfChildren
Specifies average of leaf descendants in time. Average does not count an empty value as 0.
QUESTION 69
You are developing a SQL Server Analysis Services (SSAS) cube for the sales department at your company. The sales department requires the following set of metrics:
– Unique count of customers
– Unique count of products sold
– Sum of sales
You need to ensure that the cube meets the requirements while optimizing query response time. What should you do? (Each answer presents a complete solution. Choose all that apply.)
A. Place the measures in a single measure group.
B. Place the distinct count measures in separate measure groups.
C. Use the additive measure group functions.
D. Use the semiadditive measure group functions.
E. Use the Count and Sum measure aggregation functions.
F. Use the Distinct Count and Sum measure aggregation functions.
Answer: BD
Explanation:
B: Typically, the best performance occurs when each distinct count measure is in its own measure group, and that measure group has the same dimensionality as the initial measure group.
D: Semiadditive Function
Select the aggregation function for the selected measure. The aggregate functions available include DistinctCount, Aggregated using the DistinctCount function.
QUESTION 70
Drag and Drop Questions
You are using Multidimensional Expressions (MDX) to query a SQL Server Analysis Services (SSAS) cube. You need to compute the aggregate value of the 10 most-ordered produces in the Product Categories hierarchy. The Product level is the lowest in the hierarchy. Which functions should you use to complete the MDX query? (To answer, drag the appropriate functions from the list of functions to the correct locations in the answer area.)
Explanation:
*Aggregate:
Returns a number that is calculated by aggregating over the cells returned by the set expression.
If a numeric expression is not provided, this function aggregates each measure within the current query context by using the default aggregation operator that is specified for each measure. If a numeric expression is provided, this function first evaluates, and then sums, the numeric expression for each cell in the specified set.
* TopCount: Sorts a set in descending order and returns the specified number of elements with the highest values.
* Leaves:
Returns a set composed of all attributes (optionally limited to those belonging to a specific dimension). For each attribute x in the return set, if x is the granularity attribute or is directly or indirectly related to the granularity attribute, the granularity is set on attribute x without affecting the slice. The Leaves function is designed for use inside a SCOPE statement or at the left side of an assignment.
* DESCENDANTS
Returns the set of descendants of a member at a specified level or distance, optionally including or excluding descendants in other levels.
* Incorrect: TopSUM: Returns, in order of decreasing rank, the top-most rows of a table whose cumulative total is at least a specified value.
If you want to pass Microsoft 70-466 successfully, donot missing to read latest lead2pass Microsoft 70-466 dumps.
If you can master all lead2pass questions you will able to pass 100% guaranteed.