What is the easiest way to ensure that users can receive reports according to the schedules and format they specify?

You work as a Database Administrator (DBA) at a company named ABC.com.
A Windows Server 2012 server named ABC-SSRS01 runs SQL Server 2012 Reporting
Services (SSRS).
A Windows Server 2008R2 server named ABC-Mail1 runs the Simple Mail Transport
Protocol (SMTP) service.
ABC-SSRS01 has a report named CorpReport1. Users will subscribe to CorpReport1 using
various schedules and reporting formats. The schedules and format information is entered
in a table by a custom application. The reports will be emailed using ABC-Mail1.
What is the easiest way to ensure that users can receive reports according to the
schedules and format they specify?

You work as a Database Administrator (DBA) at a company named ABC.com.
A Windows Server 2012 server named ABC-SSRS01 runs SQL Server 2012 Reporting
Services (SSRS).
A Windows Server 2008R2 server named ABC-Mail1 runs the Simple Mail Transport
Protocol (SMTP) service.
ABC-SSRS01 has a report named CorpReport1. Users will subscribe to CorpReport1 using
various schedules and reporting formats. The schedules and format information is entered
in a table by a custom application. The reports will be emailed using ABC-Mail1.
What is the easiest way to ensure that users can receive reports according to the
schedules and format they specify?

A.
For every row in the schedule table, configure a separate standard SSRS subscription.

B.
For every row in the schedule table, configure a separate data-driven SSRS subscription.

C.
Configure a single data-driven SSRS subscription. Configure the subscription schedule to
check the table for report schedules and format settings specified by the users.

D.
Configure a separate standard SSRS subscription for each different schedule specified by the
users.

Explanation:



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Mahmoud Ibrahim

Mahmoud Ibrahim

C Correct