You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008. Now you are employed in a
company which is named NaproStar and work as the technical support for the company
which uses SQL Server2008. To meet the business development’a SQL Server 2008
Analysis Services (SSAS) solution is created. Then a dimension named DimClient is created
with the three attributes of Client, Age and Name. Of the three attributes, the Client is the
key. There is a measure group named Production with the Granularity property set to Age
and DimClient is related to this group. Now you receive an e-mail from your company CIO,
according to his requirement, you should make sure that measure values can be retrieved
based on the Age and Name attributes. To achieve this goal, what action should you
perform?
A.
First the source attribute should be set to Age and the related attribute should be set to
Client, and then the source attribute should be set to Name and the related attribute should
be set to Client
B.
First the source attribute should be set to Name and the related attribute should be set to
Client, and then the source attribute should be set to Age and the related attribute should be
set to Client
C.
First the source attribute should be set to Client and the related attribute should be set to
Age, and then the source attribute should be set to Age and the related attribute should be
set to Name.
D.
First the source attribute should be set to Age and the related attribute should be set to
Client, and then the source attribute should be set to Name and the related attribute should
be set to Age
E.
First the source attribute should be set to Client and the related attribute should be set to
Age, and then the source attribute should be set to Client and the related attribute should be
set to Name
Explanation:
p .213
To create a new attribute relationship, follow these steps:
1. In the Attributes pane, right-click the source attribute that is on the “one” side of the
relationship, and then select New Attribute Relationship.
2. Configure the relationship by using the Create Attribute Relationship dialog box
Make sure that the Name drop-down list below Source Attribute shows the attribute that is
on the “many” side of the relationship and that the Name drop-down list below Related
Attribute
shows the attribute on the “one” side of the relationship. Use the Relationship Type dropdown list to specify a Flexible or Rigid relationship type. You can also create a new
relationship in the Dimension Designer by dragging the source attribute onto the related
attribute in the Diagram pane.
To delete an attribute relationship, select the relationship in the Attribute Relationships pane
(or click the arrow connector in the Diagram pane) and then press Delete,
