Microsoft
70-448 · Question #142
70-448 Question #142: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #142. The question stem and answer options stay visible for context.
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. 2008 Analysis Services (SSAS) solution is created. You also create a dimension named DimCustomer. Following is the cube structure: (Click the Exhibit button.) Now you get an order from your company CIO, according to his requirement, you should make sure that you can aggregate the Amount measure for the DimCustomer dimension. What action should you perform to achieve that goal?
Exhibit
Options
- AA many-to-many relationship should be created between FactTransaction and DimCustomer.
- BA many-to-many relationship should be created between FactCustomerAccount and DimCustomer.
- CA regular relationship should be created between FactCustomerAccount and DimCustomer.
- DA regular relationship should be created between FactTransaction and DimCustomer
- EA referenced relationship should be created between FactCustomerAccount and DimCustomer.
Unlock 70-448 to see the answer
You've previewed enough free 70-448 questions. Unlock 70-448 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.