exam questions

Exam 70-768 All Questions

View all questions & answers for the 70-768 exam

Exam 70-768 topic 1 question 18 discussion

Actual exam question from Microsoft's 70-768
Question #: 18
Topic #: 1
[All 70-768 Questions]

DRAG DROP -
You are writing a MDX query to retrieve data from a Microsoft SQL Server Analysis Services (SSAS) cube named Channel Sales. The cube defines two measures named Sales and Cost. The cube also defines a Date dimension and a Product dimension.
You need to retrieve profit values for a year named CY2016.
How should you complete the MDX statement? To answer, drag the appropriate MDX segment 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.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
References: https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/mdx/working-with-members-tuples-and-sets-mdx

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
othman_ee
4 years, 4 months ago
Answer is correct
upvoted 2 times
...
panal
4 years, 5 months ago
I Think Answer is Correct
upvoted 3 times
...
Jrestrepo
4 years, 10 months ago
Year named "CY2016", would that mean that he value in the Year Field is "CY2016" and therefore the Where statement should be: WHERE ([Date].[Year] = [CY2016])
upvoted 1 times
Kartheek285
4 years, 7 months ago
Hi, In MDX WHERE statement doesn't use = like SQL server. So the answer here is ([Date].[Year].[2016]
upvoted 9 times
...
...
z8zhong
5 years, 2 months ago
should the slicer be [Date].[Year].&[2016] ?
upvoted 2 times
lisawsan
4 years, 11 months ago
Both are correct. [CY2016] is the name and &[2016] the key
upvoted 3 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago