Microsoft
70-448 · Question #320
70-448 Question #320: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #320. 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) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL Server 2008. You work as the technical support. Now you receive an e-mail from your company CIO, in the e- mail, 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?
Options
- ABetween the DimDay dimension and the FinishedSales measure group, a many-to-many relationship
- BBetween the DimDay dimension and the FinishedSales measure group, a reference relationship should
- CBetween the DimDay dimension and the FinishedSales measure group, two regular relationships should
- DBetween the DimDay dimension and the FinishedSales measure group, two regular relationships should
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.