DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to reuse a measure group from a different database.
In SQL Server Data Tools (SSDT), which three actions should you perform in sequence? (To
answer, move the appropriate actions from the list of actions to the answer area and arrange
them in the correct order.)
Answer: See the explanation.
Explanation:
Box 1:
Box 2:
Box 3:
Note:
* You can use the Linked Object Wizard to either link to or import cubes, dimensions,
measure groups, calculations, and Key Performance Indicators (KPIs). You can link to or
import these items from another database on the same server or from a database on a
remote server
* On the Select a Data Source page of the Linked Object Wizard, choose the Analysis
Services data source or create a new one.
* On theSelect Objectspage of the wizard, choose the dimensions you want to link to in the
remote database. You cannot link to linked dimensions in the remote database.
* Incorrect:
The Business Intelligence Wizard can guide you through some or all the following steps:
Define time intelligence for cubes.
Define account intelligence for cubes and dimensions.
Define dimension intelligence for cubes and dimensions.
Define unary operators for cubes.
Set custom member formulas for cubes and dimensions.
Specify attribute ordering for dimensions.
Enable dimension writeback for dimensions.
Define semi-additive behavior for cubes.
Define currency conversion for cubes.
Reference: Using Linked Objects in a Cube
Answer :
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image027.jpg
0
0
yes
0
0
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image0251.jpg
0
0
A linked measure group can only use a linked dimension from the same source database . So need to get a measure group and associated dimension.
0
0
Agree measure group and dimension else there is no point to link Measure group
0
0
Rethink again; according to following link, select on the Measure Group that you need to link could actually also work.
https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/linked-measure-groups
The measures contained in a linked measure group can be directly organized only along linked dimensions retrieved from the same Analysis Services database. However, you can use calculated members to relate information from linked measure groups to the other, non-linked dimensions in your cube. You can also use an indirect relationship, such as a reference or many-to-many relationship, to relate non-linked dimensions to a linked measure group.
0
0