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?
A.
Between the DimProductOrders dimension and the ProductNumber measure group, you
should develop a virtual dimension relationship.
B.
Between the DimProductOrders dimension and the ProductNumber measure group, you
should develop a fact dimension relationship.
C.
Between the DimProductOrders dimension and the ProductKey measure group, you
should develop a fact dimension relationship.
D.
Before configuring the Granularity attribute to ProductKey and the measure group
columns to ProductNumber, you should you should develop a fact dimension relationship.
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.
Referenced Used when a given dimension is related to a measure group through an
intermediate 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.
EXAM TIP
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.