You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008.
You work as the technical support. Now you receive an e-mail from your company CIO, in
the email, the CIO assigns a task to you.
You use SQL Server 2008 Reporting Services (SSRS) to create a solution. You enable
proactive caching for a partition.
A data source view (DSV) is added to the solution. The DSV contains a table which is
named Worker.
The table has two columns: WorkerKey and ExecutiveKey.
The ExecutiveKey column references the executive of the workers.
In the DSV, you have to define the relationship between the employees and their manager.
What action should you perform?
A.
You should use WorkerKey as the source column and ExecutiveKey as the destination
column to create a relationship
B.
A Named Calculation should be created. The Name Calculaton uses WorkerKey and
ExecutiveKey
C.
You should use ExecutiveKey as the source column and WorkerKey as the destination
column to create a relationship.
D.
A Named Query should be created. The Named Query uses a relationship with
WorkerKey as the source column and ExecutiveKey as the destination column
Explanation:
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 Ne 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,