Microsoft
70-768 · Question #49
70-768 Question #49: Real Exam Question with Answer & Explanation
The correct answer is D. Add a measure that uses the DistinctCount aggregate function to an existing measure group.. See the full explanation below for the reasoning.
Question
You are creating a SQL Server Analysis Services (SSAS) cube. You need to create a time dimension. It must be linked to a measure group named Sales at the day granularity level. It must also be linked to a measure group named Salary at the month granularity level. What should you do?
Options
- ACreate a new named calculation in the data source view to calculate a rolling sum. Add a
- BAdd a measure group that has one measure that uses the DistinctCount aggregate function
- CCreate a dimension with one attribute hierarchy. Set the IsAggregatable property to False and
- DAdd a measure that uses the DistinctCount aggregate function to an existing measure group.
Community Discussion
No community discussion yet for this question.