nerdexam
Microsoft

70-448 · Question #318

70-448 Question #318: Real Exam Question with Answer & Explanation

The correct answer is C. You should use ExecutiveKey as the source column and WorkerKey as the destination column to. 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 Relations

Question

You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL Server 2008. 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?

Options

  • AYou should use WorkerKey as the source column and ExecutiveKey as the destination column to
  • BA Named Calculation should be created. The Name Calculaton uses WorkerKey and ExecutiveKey
  • CYou should use ExecutiveKey as the source column and WorkerKey as the destination column to
  • DA Named Query should be created. The Named Query uses a relationship with WorkerKey as the

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,

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-448 Practice