nerdexam
Microsoft

70-332 · Question #61

You need to implement a Reporting Services solution. What should you do?

The correct answer is C. Install Microsoft SQL Server 2012 Reporting Services on PROD-APP-02 in SharePoint integrated mode. On the SQL Server Feature Selection page, select Reporting Services - SharePoint. To install SQL Server 2012 Reporting Services in SharePoint integrated mode on an application server, the correct feature selection is 'Reporting Services - SharePoint', not the add-in component.

Configure and manage service applications

Question

You need to implement a Reporting Services solution. What should you do?

Options

  • AUse Reporting Services Configuration Manager to add an additional report server to PROD-APP-02.
  • BInstall Microsoft SQL Server 2012 Reporting Services on PROD-APP-02 in a SharePoint integrated mode. On the SQL Server Feature Selection page, select Reporting Services add-in for SharePoint products.
  • CInstall Microsoft SQL Server 2012 Reporting Services on PROD-APP-02 in SharePoint integrated mode. On the SQL Server Feature Selection page, select Reporting Services - SharePoint.
  • DUninstall Microsoft SQL Server 2012 Reporting Services on PROD-APP-01. Install Reporting Services on PROD-WEB-01 and PROD-WEB-02. Add the report server URL to the load-balance pool.

How the community answered

(34 responses)
  • A
    3% (1)
  • B
    6% (2)
  • C
    76% (26)
  • D
    15% (5)

Why each option

To install SQL Server 2012 Reporting Services in SharePoint integrated mode on an application server, the correct feature selection is 'Reporting Services - SharePoint', not the add-in component.

AUse Reporting Services Configuration Manager to add an additional report server to PROD-APP-02.

Reporting Services Configuration Manager manages native mode report servers and cannot add a server to a SharePoint integrated mode deployment.

BInstall Microsoft SQL Server 2012 Reporting Services on PROD-APP-02 in a SharePoint integrated mode. On the SQL Server Feature Selection page, select Reporting Services add-in for SharePoint products.

Selecting 'Reporting Services add-in for SharePoint products' installs only the front-end integration components for SharePoint WFE servers, not the full SSRS service that must run on the application server.

CInstall Microsoft SQL Server 2012 Reporting Services on PROD-APP-02 in SharePoint integrated mode. On the SQL Server Feature Selection page, select Reporting Services - SharePoint.Correct

When installing SSRS in SharePoint integrated mode on an application server, you must select 'Reporting Services - SharePoint' on the Feature Selection page, which installs the actual report server service as a SharePoint shared service. This is distinct from the RS add-in, which is a separate component installed on SharePoint web front-end servers to provide UI integration.

DUninstall Microsoft SQL Server 2012 Reporting Services on PROD-APP-01. Install Reporting Services on PROD-WEB-01 and PROD-WEB-02. Add the report server URL to the load-balance pool.

SSRS in SharePoint integrated mode cannot be placed on web servers and load-balanced via a URL pool; it runs as a SharePoint shared service on application servers.

Concept tested: SQL Server 2012 SSRS SharePoint integrated mode installation

Source: https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/install-reporting-services-sharepoint-mode

Topics

#SSRS integration#SharePoint integrated mode#SQL Server features#report server

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-332 Practice