Exam 70-768 topic 1 question 16 discussion

Actual exam question from Microsoft's 70-768

Question #: 16
Topic #: 1

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

You must create a report that shows, for each month, the Internet sales for that month and the total Internet sales for the calendar year up to and including the current month.
You create the following MDX statement (Line numbers are included for reference only.):

You need to complete the MDX statement to return data for the report.
Which MDX segment should you use in line 01?

A.

B.

C.

D.

Show Suggested Answer

Suggested Answer: B
The following example returns the sum of the Measures. [Order Quantity] member, aggregated over the first eight months of calendar year 2003 that are contained in the Date dimension, from the Adventure Works cube.

Copy -
WITH MEMBER [Date].[Calendar].[First8Months2003] AS
Aggregate(
PeriodsToDate(
[Date].[Calendar].[Calendar Year],
[Date].[Calendar].[Month].[August 2003]
)
)

SELECT -
[Date].[Calendar].[First8Months2003] ON COLUMNS,
[Product].[Category].Children ON ROWS

FROM -
[Adventure Works]

WHERE -
[Measures].[Order Quantity]
References:https://docs.microsoft.com/en-us/sql/mdx/aggregate-mdx

by ialberto at Aug. 25, 2020, 11:03 a.m.

Comments

Submit Cancel

othman_ee

4 years, 4 months ago

Going with B

upvoted 2 times

...

panal

4 years, 6 months ago

I think B is Correct

upvoted 3 times

...

ialberto

4 years, 8 months ago

I think it's A because we want every month of the year and the current month itself. Accordingly with the explanation and code written it's A.

upvoted 1 times

null

4 years, 8 months ago

the options are referring to the code above them, A refers to the one with QTD (which is not correct). B seems to be the correct one.

upvoted 4 times

...

Exam 70-768 All Questions

View all questions & answers for the 70-768 exam