Microsoft
70-448 · Question #93
You are developing a SQL Server 2008 Analysis Services (SSAS) solution which contains a data source view (DSV) which owns a table called Worker for Company.com. There are some columns in the Worker…
The correct answer is D. through utilizing BossKey, you should develop a relationship as the source column and WorkerKey. See the full explanation below for the reasoning.
Question
You are developing a SQL Server 2008 Analysis Services (SSAS) solution which contains a data source view (DSV) which owns a table called Worker for Company.com. There are some columns in the Worker below
- WorkerKey
- BossKey
The BossKey column references the manager of the Workers. You should make sure that you should create the relationship between the workers and their boss in the DSV. Which is the correct answer?
Options
- AYou should develop a Calculation which utilizes WorkerKey and BossKey
- BYou should develop a View which utilizes a relationship with WorkerKey as the source column and
- CYou should develop a Query which utilizes a relationship with WorkerKey as the source column and
- Dthrough utilizing BossKey, you should develop a relationship as the source column and WorkerKey
How the community answered
(17 responses)- A12% (2)
- B6% (1)
- C6% (1)
- D76% (13)
Community Discussion
No community discussion yet for this question.