Microsoft
70-768 · Question #52
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…
The correct answer is D. Add a measure that uses the Count aggregate function to an existing measure group. See the full explanation below for the reasoning.
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.
How the community answered
(19 responses)- A11% (2)
- C5% (1)
- D84% (16)
Community Discussion
No community discussion yet for this question.