You are adding dimensions and a new measure group named Service Quality to an existing
SQL Server Analysis Services (SSAS) cube.
Date is one of the existing dimensions in the SSAS database. The underlying fact table for
the measure group is associated with multiple dates, including FirstServiceDate,
SecondServiceDate, and ThirdServiceDate.
You need to ensure that users can slice the Service Quality measures by FirstServiceDate,
SecondServiceDate, and ThirdServiceDate. You also need to ensure that the time required
to process the database is minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
A.
Create cube dimensions named FirstServiceDate. SecondServiceDate, and
ThirdServiceDate by using the existing date dimension in the database.
B.
Create three independent dimensions named FirstServiceDate, SecondServiceDate, and
ThirdServiceDate and then link all three of them to the Service Quality measure group.
C.
Create three new perspectives named FirstServiceDate. SecondServiceDate, and
ThirdServiceDate.
D.
Add three attributes named FirstServiceDate. SecondServiceDate, and ThirdServiceDate
to the existing date dimension in the database.
A.
Create cube dimensions named FirstServiceDate. SecondServiceDate, and
ThirdServiceDate by using the existing date dimension in the database.
Agreed, A is the correct answer, using role-playing dims to address multiple date columns while minimizing processing time.
“A”
A is the correct answer
Disagree. ‘C’ as perspectives have little effect on processing.
http://thatmsftbiguy.com/ssasperspectives/
A.