Microsoft
70-467 · Question #172
70-467 Question #172: Real Exam Question with Answer & Explanation
The correct answer is D: Create one data-driven SSRS subscription. Schedule the subscription to frequently retrieve. A single data-driven SSRS subscription reads delivery parameters dynamically from the schedule table, eliminating the need to create or manage individual subscriptions for each user.
Question
You are designing a subscription strategy for a SQL Server Reporting Services (SSRS) report. You have an application that populates a table with user-specific subscription schedules and report formats. You need to ensure that users can receive reports by email according to their preferences. Email messages will be sent via an internal mail server. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Options
- ACreate a standard SSRS subscription for each record in the table.
- BCreate a data-driven SSRS subscription for each record in the schedule table.
- CCreate a standard SSRS subscription for each subscription schedule.
- DCreate one data-driven SSRS subscription. Schedule the subscription to frequently retrieve
Explanation
A single data-driven SSRS subscription reads delivery parameters dynamically from the schedule table, eliminating the need to create or manage individual subscriptions for each user.
Common mistakes.
- A. Standard subscriptions have static parameters; creating one per table record ignores the dynamic schedule and format data already stored in the table and creates an unmanageable number of static subscriptions.
- B. Creating a data-driven subscription per record defeats the purpose of data-driven subscriptions, which are designed to fan out to multiple recipients in a single run rather than one subscription per row.
- C. Standard subscriptions per schedule cannot read user-specific format preferences from a table and still require manual creation for every schedule variation.
Concept tested. SSRS data-driven subscriptions with dynamic delivery parameters
Community Discussion
No community discussion yet for this question.