Microsoft
70-768 · Question #52
70-768 Question #52: Real Exam Question with Answer & Explanation
Sign in or unlock 70-768 to reveal the answer and full explanation for question #52. The question stem and answer options stay visible for context.
Question
You are developing a SQL Server Analysis Services (SSAS) cube. The data warehouse has a table named FactStock that is used to track movements of stock. A column named MovementQuantity contains quantities of stock. A positive quantity is used for input and negative quantity is used for output. A column named MovementDate is related to the time dimension. The quantity in stock, at a given point in time, can be evaluated as the sum of all MovementQuantity values at that point in time. You need to create a measure that calculates the quantity in stock value. What should you do?
Options
- ACreate several dimensions. Add each dimension to the cube.
- BAdd a measure that uses the DistinctCount aggregate function to an existing measure group.
- CCreate a dimension. Create regular relationships between the cube dimension and the measure
- DAdd a measure that uses the Count aggregate function to an existing measure group.
Unlock 70-768 to see the answer
You've previewed enough free 70-768 questions. Unlock 70-768 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.