You are developing the database schema for a SQL Server Analysis Services (SSAS) BI
Semantic Model (BISM). The BISM will be based on the schema displayed in the following graphic.
You have the following requirements:
Ensure that queries of the data model correctly display average student age by class.
Ensure that the solution supports role-based security and partitions.
Minimize development effort.
You need to design the data model.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
A.
Create a multidimensional project and define measures and a many-to-many dimensional
relationship. Create partitions in SQL Server Management Studio (SSMS).
B.
Create a multidimensional project and define measures and a reference relationship.
Create partitions in SQL Server Data Tools (SSDT).
C.
Create a tabular project and define measures. Create partitions in SQL Server Data Tools
(SSDT).
D.
Create a tabular project and define calculated columns. Create partitions in SQL Server
Management Studio (SSMS).
Why not C ?
Similar to Q 21
not the same question as 21:
‘Ensure that queries of the data model correctly display average student age by class and
average class level by student.’ -> this is definatly many to many.
but current question, i don’t know, but i would guess answer stays the same?
It’s not C because of requirement
“Ensure that the solution supports role-based security and partitions.”
Tabular only supports row level security.
row filters*
I’m wrong. Tabular does support role level security and can granularly set security using row filters.
The reason this is not C is because you have to use a many-to-many relationship and none of the tabular answers have that option.
Agree with Jane.