Microsoft
70-448 · Question #143
70-448 Question #143: Real Exam Question with Answer & Explanation
The correct answer is C. A Truth dimension relationship should be created between the TruthBills measure group and DimBills. See the full explanation below for the reasoning.
Question
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server 2008 Analysis Services (SSAS) solution. You have a table named Bills with three columns contained. They are respectively Shipper, BillKey and BillQuantity. To meet the business development, a dimension named DimBills and a measure group named TruthBills are created from the Bills table. Besides, the BillKey is set as a key column and the Shipper is set as an attribute column. According to the order of the CIO, a dimension relationship between the BillQuantity column and the Shipper column should be created to make sure that the Shipper column is able to aggregate BillQuantity column. What action below should be performed to achieve this goal?
Options
- AA regular dimension relationship should be created between the DimBills dimension and the TruthBills
- BThe relationship between the TruthBills measure group and DimBills dimension should be set to No
- CA Truth dimension relationship should be created between the TruthBills measure group and DimBills
- DA regular dimension relationship should be created between the DimBills dimension and the TruthBills
- EA regular dimension relationship should be created between the DimBills dimension and the TruthBills
Community Discussion
No community discussion yet for this question.