PrepAway - Latest Free Exam Questions & Answers

How should you complete the MDX statement?

DRAG DROP
You are a business analyst for a retail company that uses a Microsoft SQL Server Analysis Services (SSAS) multidimensional database to track sales. The database contains the following objects:

Your company is developing a promotional plaque to recognize the top resellers in the top 10 cities where the company does business. Each plaque must display the sales total for all resellers in the city. In addition, the plaque must display a total for all cities not in the top 10.
You have the following requirements:
You must use total sales for a city to determine the top cities.
You must specify a color and material for each plaque. The color and materials used will be different for the resellers in each city, and will be based on how the total for a city compares to other cities in the top 10 list.
You need to provide the information needed for the promotional plaques.
How should you complete the MDX statement? To answer, drag the appropriate MDX segments to the correct locations. Each MDX segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

PrepAway - Latest Free Exam Questions & Answers

Answer:

Explanation:
Box 1:DYNAMIC SET
Box 2:MEMBER
Box 3:DYNAMIC SET
Box 4:[Geography].[City].[City].members
Box 5:[Measures].[Reseller Sales Amount]
Reference: https://docs.microsoft.com/en-us/sql/mdx/aggregate-mdx


Leave a Reply