Microsoft
70-467 · Question #11
70-467 Question #11: Real Exam Question with Answer & Explanation
The correct answer is C: Create one data-driven subscription. Schedule the subscription to frequently retrieve user. A single SSRS data-driven subscription queries the user preference table at delivery time to dynamically determine each recipient's schedule, format, and email address without requiring per-user subscription management.
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. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Options
- ACreate a standard subscription for each record in the table.
- BCreate a data-driven subscription for each record in the schedule table.
- CCreate one data-driven subscription. Schedule the subscription to frequently retrieve user
- DCreate a standard subscription for each subscription schedule.
Explanation
A single SSRS data-driven subscription queries the user preference table at delivery time to dynamically determine each recipient's schedule, format, and email address without requiring per-user subscription management.
Common mistakes.
- A. Standard subscriptions use static delivery parameters set at creation time and cannot query a table for per-user preferences, so creating one per record still does not honor dynamic changes to user schedules or formats.
- B. Creating a separate data-driven subscription for each record in the table replicates the administrative overhead of managing many subscriptions and negates the core benefit of data-driven delivery, which is to serve multiple recipients from a single subscription.
- D. Standard subscriptions cannot retrieve delivery parameters from an external data source, so assigning one per schedule still results in static, user-agnostic configurations that do not adapt to the per-user format and timing preferences stored in the application table.
Concept tested. SSRS data-driven subscription with dynamic delivery parameters
Community Discussion
No community discussion yet for this question.