70-466 · Question #89
You need to develop the multidimensional project to meet the requirements of the Excel users. What should you do?
The correct answer is B. Create a perspective for the executive team.. In SSAS Multidimensional, a perspective provides a simplified, focused subset of a cube's objects for specific user groups without duplicating cube data or changing security.
Question
Options
- ACreate a separate cube for the executive team so that it contains only the data they want to see.
- BCreate a perspective for the executive team.
- CCreate security roles to restrict access to the executive team.
- DCreate a view for the executive team.
How the community answered
(23 responses)- A4% (1)
- B96% (22)
Why each option
In SSAS Multidimensional, a perspective provides a simplified, focused subset of a cube's objects for specific user groups without duplicating cube data or changing security.
Creating a separate cube duplicates infrastructure, increases processing overhead, and creates maintenance burden when the same result can be achieved with a lightweight perspective.
A perspective in SSAS Multidimensional is a named, curated subset of cube metadata - measures, dimensions, KPIs, and calculated members - that reduces complexity for targeted user groups like executives without requiring a separate cube or affecting underlying data access.
Security roles restrict data access based on permissions but do not simplify or filter the visible metadata of a cube for usability purposes.
A view is a relational database concept applicable to SQL Server tables, not a valid construct within an SSAS Multidimensional project for customizing cube visibility.
Concept tested: SSAS Multidimensional perspectives for user-focused views
Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/perspectives-in-multidimensional-models
Topics
Community Discussion
No community discussion yet for this question.