You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A Windows Server 2012 server named ABC-SSAS01 runs SQL Server 2012 Analysis
Services (SSAS).
You are creating a BI Semantic Model (BISM). The graphic below shows the schema that
the BISM will be based on.
You are planning the data model. Your data model must support queries to display the
average number of employee years of service by factory. You need to configure the
solution to support partitions and role-based security whilst minimizing development
effort.
Which four of the following should you include in your design? (Choose four).
A.
A tabular project should be created.
B.
A multidimensional model should be created.
C.
Measures should be defined.
D.
Calculated columns should be defined.
E.
A reference relationship should be configured.
F.
A many-to-many dimensional relationship should be configured
G.
Partitions should be created using SQL Server Data Tools (SSDT).
H.
Partitions should be created using SQL Server Management Studio (SSMS).
Explanation:
Shouldn`t it be BCEG ??
It should be BCEG
It is Many to Many relationship.
Also you can create partitions using SSDT or SSMS.