70-448 · Question #46
You are developing a SQL Server 2008 Analysis Services (SSAS) method for Company.com. There is a table called Product which includes listed columns below: - ProductKey - Logger - ProductNumber…
The correct answer is B. Between the DimProductOrders dimension and the ProductNumber measure group, you should develop. Dimension Usage Relationship Types Relationship type purpose Regular Defines the relationship when a dimension is joined directly to a measure group through a specific attribute called the "granularity" attribute. Fact Used when the dimension is based on the fact table used to…
Question
You are developing a SQL Server 2008 Analysis Services (SSAS) method for Company.com. There is a table called Product which includes listed columns below:
- ProductKey
- Logger
- ProductNumber
Firstly you develop a dimension called DimProductOrders from the Product table, and then configure the ProductKey as a key column and the Logger column as a property. At last you create a measure group called FactProductOrders from the Product table. You should make sure that you could develop a dimension relationship . Then you could make ProductNumber column gathered by the Logger column. Which is the correct answer?
Options
- ABetween the DimProductOrders dimension and the ProductNumber measure group, you should develop
- BBetween the DimProductOrders dimension and the ProductNumber measure group, you should develop
- CBetween the DimProductOrders dimension and the ProductKey measure group, you should develop a
- DBefore configuring the Granularity attribute to ProductKey and the measure group columns to
How the community answered
(54 responses)- A15% (8)
- B78% (42)
- C6% (3)
- D2% (1)
Explanation
Dimension Usage Relationship Types Relationship type purpose Regular Defines the relationship when a dimension is joined directly to a measure group through a specific attribute called the "granularity" attribute. Fact Used when the dimension is based on the fact table used to define the measure group. dimension. Many-To-Many Specifies that a dimension is related to a given measure group through an intermediate measure group. Data Mining Defines the relationship between a dimension based on a data mining model and a given measure group. Sometimes after analyzing the database schema and designing fact and dimension tables, you will be left with columns in the fact table that do not justify moving them to designated dimension tables, such as Sales order number. yet reporting requirements might require you to let end users browse data by these columns--for example, to see all sales order line items for a given sales order. you can meet such requirements by building dimensions directly from the fact table and then joining them to the related measure groups through a fact relationship.
Topics
Community Discussion
No community discussion yet for this question.