70-467 · Question #174
Your network contains the following components: - Microsoft SharePoint Server 2010 - SQL Server 2008 Service Pack 2 (SP2) - SQL Server 2008 Service Pack 1 (SP1) in Reporting Services Native Mode You…
The correct answer is A. Install a SQL Server 2014 Reporting Services add-in for SharePoint on all of the front-end E. Migrate legacy reports and application data. F. Install a new instance of SQL Server Reporting Services (SSRS) 2014. Switching from SSRS Native Mode to SharePoint Integrated Mode requires installing the SSRS add-in on SharePoint front-end servers, deploying a fresh SSRS 2014 instance configured for SharePoint mode, and migrating existing report content.
Question
Your network contains the following components:
- Microsoft SharePoint Server 2010
- SQL Server 2008 Service Pack 2 (SP2)
- SQL Server 2008 Service Pack 1 (SP1) in Reporting Services Native
Mode You need to recommend a solution to upgrade the network to SQL Server 2014.
- The solution must meet the following requirements:
- Minimize the amount of time that SharePoint services are unavailable.
- Deploy the upgraded Reporting Services instance in Reporting Services
SharePoint Integrated Mode. You upgrade the Database Engine to SQL Server 2014. Which three actions should you recommend performing next? Each Answer presents part of the solution.
Options
- AInstall a SQL Server 2014 Reporting Services add-in for SharePoint on all of the front-end
- BPerform an in-place upgrade to SQL Server Reporting Services (SSRS) 2014.
- CPerform a SharePoint 2013 side-by-side upgrade.
- DPerform a SharePoint 2013 in-place upgrade.
- EMigrate legacy reports and application data.
- FInstall a new instance of SQL Server Reporting Services (SSRS) 2014.
How the community answered
(44 responses)- A61% (27)
- B20% (9)
- C7% (3)
- D11% (5)
Why each option
Switching from SSRS Native Mode to SharePoint Integrated Mode requires installing the SSRS add-in on SharePoint front-end servers, deploying a fresh SSRS 2014 instance configured for SharePoint mode, and migrating existing report content.
The SQL Server 2014 Reporting Services add-in for SharePoint must be installed on every SharePoint front-end web server to enable the SharePoint Integrated Mode integration, allowing report viewing and management through SharePoint.
An in-place upgrade of the existing SSRS instance retains Native Mode and cannot convert the instance to SharePoint Integrated Mode, which requires a fresh installation with a different configuration.
A SharePoint 2013 side-by-side upgrade is not one of the three recommended steps; the focus is on the SSRS deployment path, and a side-by-side SharePoint upgrade is a separate, optional strategy not required by the stated solution.
A SharePoint 2013 in-place upgrade was not selected as part of the recommended three actions; the requirements focus on minimizing SharePoint unavailability and the SSRS mode change, not forcing a specific SharePoint upgrade method.
Legacy reports, data sources, and subscriptions from the existing Native Mode instance must be explicitly migrated to the new SharePoint Integrated instance because the two modes use incompatible storage architectures.
SharePoint Integrated Mode cannot be achieved by upgrading an existing Native Mode installation in-place; a new SSRS 2014 instance must be installed and configured specifically in SharePoint mode.
Concept tested: Upgrading SSRS from Native Mode to SharePoint Integrated Mode
Source: https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/migrate-a-reporting-services-installation-sharepoint-mode
Topics
Community Discussion
No community discussion yet for this question.