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? (Exhibit)
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 boxMake 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 drop-down 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,