Administering Microsoft SQL Server 2012/2014 Databases — Question 32

You administer a Microsoft SQL Server environment. The environment contains a SQL Server Reporting Services (SSRS) instance.
You need to ensure that users can create subscriptions.
What should you configure?

Answer options

• A. item security for the reports
• B. SQL Agent Proxy Account
• C. SSRS Execution Account
• D. processing options for the reports A

Correct answer:

Explanation

To allow users to create subscriptions in SSRS, you need to configure item security for the reports, as this grants the necessary permissions to users. The other options, such as SQL Agent Proxy Account and SSRS Execution Account, are related to execution and job running but do not directly impact subscription creation permissions.