You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008.
You work as the technical support. Now you receive an e-mail from your company CIO, in
the email, the CIO assigns a task to you.
You use SQL Server 2008 Reporting Services (SSRS) to create a solution.
There is a time dimension named DimDay in the solution.
There is a table named FinishedSales. This table contains two columns both of which refer
to the DimDay dimension.
The two columns are respectively named BillDate and MailDate.
Now you get an e-mail from your company CIO, in the e-mail the CIO posts a requirement.
The DimDay dimension must be able to be used to browse through measures in the
FinishedSales table for both BillDate and MailDate.
You have to ensure this. So what action should you perform?
A.
Between the DimDay dimension and the FinishedSales measure group, a many-to-many
relationship should be created.
B.
Between the DimDay dimension and the FinishedSales measure group, a reference
relationship should be created
C.
Between the DimDay dimension and the FinishedSales measure group, two regular
relationships should be created. After you create the two relationships, you should use
different measure group columns
D.
Between the DimDay dimension and the FinishedSales measure group, two regular
relationships should be created. After you create the two relationships, you should use
identical measure group columns.