Microsoft
70-448 · Question #234
Your company network includes a SQL Server 2008 R2 database server with the SQL Server 2008 Analysis Services (SSAS) role enabled. You design a cube named Materials with a measure group named…
The correct answer is D. Define the QuantityOnHand measure as a semi-additive measure. See the full explanation below for the reasoning.
Question
Your company network includes a SQL Server 2008 R2 database server with the SQL Server 2008 Analysis Services (SSAS) role enabled. You design a cube named Materials with a measure group named MaterialsInventory. This group has a measure, QuantityOnHand, which shows the total stock in inventory for the company by time. You need to determine the inventory at the end of a quarter. What should you do?
Options
- ADefine the MaterialsInventory group as a semi-additive measure group.
- BDefine the MaterialsInventory group as an additive measure group.
- CDefine the QuantityOnHand measure as an additive measure.
- DDefine the QuantityOnHand measure as a semi-additive measure.
How the community answered
(35 responses)- A14% (5)
- B3% (1)
- C9% (3)
- D74% (26)
Community Discussion
No community discussion yet for this question.