PrepAway - Latest Free Exam Questions & Answers

What should you do?

You are managing a Microsoft SQL Server 2005 Reporting Services (SSRS) instance.

The following events must occur at 2:00 on every Sunday:

A data-driven subscription for the Human Resources report must write to several file shares.
The execution of the Sales report must expire.
The history of the Manufacturing report must include a new state of the data.

You need to configure the package so that the events occur and are exposed for a single-step batch job.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Use a shared schedule and start the SQL Agent service on the SSRS database server.

B.
Use a shared schedule and disable the SQL Agent service on the SSRS database server.

C.
Use a report-specific schedule for each task and start the SQL Agent service on the SSRS database server.

D.
Use a report-specific schedule for each task and disable the SQL Agent service on the SSRS database server.


Leave a Reply