SSRS Interview Questions

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

You need to re-establish subscriptions on SSRS01. What should you do? *

5 points

Manually failover the active node

Install prerequisites and upgrade shared components on Node1 and Node2

Generate a SQL Server 2012 configuration file by running the SQL Server Setup executable

Upgrade Node1 by using the SQL Server 2012 Upgrade wizard.

You need to configure SSRS to send the required notification messages. Which configuration settings should you use? (Each correct answer presents a partial solution. Choose all that apply.) *

5 points

<SendUsing>contoso.com</SendUsing>

<SMTPServer>SMTP01/SMTPServer>

<From>reports@contoso.com</From>

Required

You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A system role named Developer Support is present on the server. Members of the Developer Support role cannot modify the report execution timeout period. You need to enable members of the Developer Support role to modify the report execution timeout period. Which task should you add to the Developer Support role? *

5 points

Manage jobs

Manage shared schedules

Execute report definitions

Manage report server properties

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.) *

5 points

Create a standard subscription for each record in the table

Create a data-driven subscription for each record in the schedule table

Create one data-driven subscription. Schedule the subscription to frequently retrieve user preferences.

Create a standard subscription for each subscription schedule

You administer a SQL Server Reporting Services (SSRS) instance in native mode. You need to assign a predefined role that meets the following requirements:  Members of the role must be able to update shared data sources.  Members of the role must not be able to consume reports or manage subscriptions.  The role must provide only the minimum permissions required. Which role should you assign? (More than one answer choice may achieve the goal. Select the BEST answer.) *

5 points

the Content Manager role

the Read and Process role

the Publisher role

the Browser role

Submit

Clear form

Forms

This content is neither created nor endorsed by Google.