Microsoft
70-768 · Question #49
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…
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.
How the community answered
(43 responses)- A2% (1)
- B7% (3)
- C16% (7)
- D74% (32)
Community Discussion
No community discussion yet for this question.