Microsoft
70-460 · Question #29
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…
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
- AUse role playing dimensions.
- BUse the Business Intelligence Wizard to define dimension intelligence.
- CAdd a measure that uses the Count aggregate function to an existing measure group.
- DAdd a measure that uses the DistinctCount aggregate function to an existing measure group.
- EAdd a measure that uses the LastNonEmpty aggregate function.
- FAdd a measure group that has one measure that uses the DistinctCount aggregate function.
- GCreate a dimension.
- HAdd a hidden measure that uses the Sum aggregate function.
Community Discussion
No community discussion yet for this question.