Microsoft
70-466 · Question #27
70-466 Question #27: Real Exam Question with Answer & Explanation
Sign in or unlock 70-466 to reveal the answer and full explanation for question #27. The question stem and answer options stay visible for context.
Build an analysis services database
Question
You are modifying a SQL Server Analysis Services (SSAS) cube. Users in the cube report that the precision for the TransactionCost measure is five digits. You need to ensure that the TransactionCost measure stores values to two digits of precision. What should you do?
Options
- AAdd a named calculation in the data source view that casts the data source column to two digits of precision. Bind the TransactionCost measure to the new column.
- BAdd a named query in the data source view that casts the data source column to two digits of precision. Bind the TransactionCost measure to the new query.
- CUse the FormatString measure property to format TransactionCost as #.##;0.00;-.#.##;0.00.
- DUse the FormatString measure property to format TransactionCost as Currency.
- EUse the MeasureExpression measure property to change the precision of TransactionCost to two digits.
Unlock 70-466 to see the answer
You've previewed enough free 70-466 questions. Unlock 70-466 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.
Topics
#measure precision#named calculation#data source view#measure binding