Which of the following relationship types should you select?

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A server named ABC-SSAS1 runs SQL Server Analysis Services (SSAS). You are
developing a cube on ABC-SSAS1.
The cube includes a dimension named Type which is based on a table named DimType.
The following image shows a portion of the data source view.

You need to configure a relationship between the Orders measure group and the Type
dimension.
Which of the following relationship types should you select?

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A server named ABC-SSAS1 runs SQL Server Analysis Services (SSAS). You are
developing a cube on ABC-SSAS1.
The cube includes a dimension named Type which is based on a table named DimType.
The following image shows a portion of the data source view.

You need to configure a relationship between the Orders measure group and the Type
dimension.
Which of the following relationship types should you select?

A.
Regular

B.
Fact

C.
Referenced

D.
Many-to-Many

E.
Data Mining

Explanation:



Leave a Reply 1

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


Mahmoud Ibrahim

Mahmoud Ibrahim

C