Microsoft
70-466 · Question #132
70-466 Question #132: Real Exam Question with Answer & Explanation
Sign in or unlock 70-466 to reveal the answer and full explanation for question #132. The question stem and answer options stay visible for context.
Build reports
Question
You need to recommend a solution to meet the requirements for the ManufacturingIssues.rdl report. What is the best solution that you should include in the recommendation? More than one answer choice may achieve the goal. Choose the BEST answer.
Options
- AAdd a dataset to the report that uses an ad hoc SQL statement. Configure the dataset to include the parameters required for the different views. Add a dataset for each parameter created.
- BAdd a dataset to the report that uses an ad hoc SQL statement. Configure the dataset to include the parameters required for the different views. Update each parameter to use a set of values from Report Designer.
- CAdd a dataset to the report that uses an ad hoc SQL statement. Configure the dataset to include the parameters required for the different views. Use the default display for the parameters.
- DAdd a dataset to the report that uses a stored procedure. Configure the dataset to include the parameters required for the different views. Update each parameter to use a set of values from Report Designer.
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
#SSRS dataset design#ad hoc SQL#stored procedure#report parameters