In the DSV, you have to define the relationship between the employees and their manager. What action should you perform?

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 e-mail, 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? (Exhibit)

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 e-mail, 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? (Exhibit)

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 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 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,

Show Hint

Leave a Reply 1

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

http://daphnepretty.com/post/2013/05/03/New-Blog.aspx

http://daphnepretty.com/post/2013/05/03/New-Blog.aspx

overall, generally there are pretty much a great limitless wide range of
companies in which a welder might work as part of. To be confident to select the appropriate welding electrodes for a specific welding career
is crucial to the welding job which can be replied to be done
well. Welding is helpful for a wide spectrum of industries anticipated to
the distinct properties which this process might alone provide.
Welders doing pipeline welding jobs, guaranteed that sections of pipe tend to be joined up with together
using the welding system.

Reply