Which three of the following should you include in your design?

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 and the average output by
employee.
Which three of the following should you include in your design? (Choose three).

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 and the average output by
employee.
Which three of the following should you include in your design? (Choose three).

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.

Explanation:



Leave a Reply 1

Your email address will not be published. Required fields are marked *


MCSE-467

MCSE-467

B, C and F.