What should you do?

You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
You are using SQL Server Data Tools (SSDT) to develop a SQL Server Analysis Services (SSAS)
cube for the Marketing department.
An Analysis Services database used by the Sales department contains a measure group that you
want to include in the Marketing department cube. The measure group must continue to reflect
changes in the Sales database when it is included in the new cube.
What should you do?

You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
You are using SQL Server Data Tools (SSDT) to develop a SQL Server Analysis Services (SSAS)
cube for the Marketing department.
An Analysis Services database used by the Sales department contains a measure group that you
want to include in the Marketing department cube. The measure group must continue to reflect
changes in the Sales database when it is included in the new cube.
What should you do?

A.
Start the Dimension Wizard. Select the Analysis Services data source. Select the Dimension
and select the Import option and save the changes.

B.
Start the Dimension Wizard. Select the Analysis Services data source. Select the Dimension
and select the Link option and save the changes.

C.
Start the Linked Object Wizard. Select the Analysis Services data source. Select the Measure
Group and select the Import option and save the changes.

D.
Start the Linked Object Wizard. Select the Analysis Services data source. Select the Measure
Group and select the Link option and save the changes.

Explanation:



Leave a Reply 1

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