You are developing a SQL Server 2008 Reporting Services (SSRS) method for Company.com.
The cube structure is listed below: For the DimCustomer dimension, you should make sure that the Amount measure could be gathered.
Which is the correct answer? (Exhibit)
A.
You should develop a one-to-many relationship between DimCustomer and FactTransaction.
B.
You should develop a many-to-one relationship between DimCustomer and FactTransaction.
C.
Before configuring FactCustomerAccount as an intermediate measure group, you should develop a many-to-many relationship between DimCustomer and FactTransaction.
D.
Before setting FactCustomerAccount as an advanced measure group, you should develop a one-to-one relationship between DimCustomer and FactTransaction.
Explanation:
Relationship type
Regular Defi nes the relationship when a dimension is joined directly to a measure group through a specifi c attribute called the granularity attribute.
Fact Used when the dimension is based on the fact table used to defi ne 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 Defi nes 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 columnsfor 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.