Microsoft
70-467 · Question #12
70-467 Question #12: Real Exam Question with Answer & Explanation
Sign in or unlock 70-467 to reveal the answer and full explanation for question #12. The question stem and answer options stay visible for context.
Design a reporting solution
Question
You are modifying a SQL Server Reporting Services (SSRS) report for a SQL Server Analysis Services (SSAS) cube. The report defines a report parameter of data type Date/Time with which users can filter the report by a single date. The parameter value cannot be directly used to filter the Multidimensional Expressions (MDX) query for the dataset. You need to ensure that the report displays data filtered by the user-entered value. You must achieve this goal by using the least amount of development effort. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Options
- AEdit the dataset query parameter. Change the Value property of the report parameter to an
- BEdit the dataset query parameter. Change the Name property of the dataset query parameter
- CEdit the dataset query parameter. Create a subcube subquery that uses the StrToSet MDX
- DChange the dataset query to Transact-SQL (T-SQL).
Unlock 70-467 to see the answer
You've previewed enough free 70-467 questions. Unlock 70-467 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
#MDX queries#SSRS parameters#SSAS integration#date filtering