Administering Microsoft SQL Server 2012/2014 Databases — Question 58

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. cache refresh options
• B. site security for service account
• C. SSRS Execution Account
• D. folder level security

Correct answer: D

Explanation

To enable users to create subscriptions in SSRS, you need to configure folder level security, as this allows you to assign the necessary permissions to users. The other options relate to different aspects of SSRS management but do not directly grant users the ability to create subscriptions.