Microsoft
70-460 · Question #30
70-460 Question #30: Real Exam Question with Answer & Explanation
Sign in or unlock 70-460 to reveal the answer and full explanation for question #30. The question stem and answer options stay visible for context.
Question
You are creating a SQL Server Analysis Services (SSAS) multidimensional database. Users need a time dimension for: - Dates - Delivery dates - Ship dates You need to implement the minimum number of required SSAS objects. What should you do?
Options
- AUse role playing dimensions.
- BUse the Business Intelligence Wizard to define dimension intelligence.
- CAdd a measure that uses the Count aggregate function to an existing measure group.
- DAdd a measure that uses the DistinctCount aggregate function to an existing measure group.
- EAdd a measure that uses the LastNonEmpty aggregate function.
- FAdd a measure group that has one measure that uses the DistinctCount aggregate function.
- GAdd a calculated measure based on an expression that counts members filtered by the Exists and
- HAdd a hidden measure that uses the Sum aggregate function.
- JCreate a dimension.
Unlock 70-460 to see the answer
You've previewed enough free 70-460 questions. Unlock 70-460 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.