You have a SQL Server Reporting Services (SSRS) 2012 instance integrated with a
Microsoft SharePoint 2010 farm.
You need to upgrade to SSRS 2014 with the minimum downtime and hardware
requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
A.
Install SSRS 2014 on a new SharePoint farm and migrate content to the new farm.
B.
Migrate SSRS content to new servers that run SSRS 2014.
C.
Migrate SSRS content to a separate instance of SSRS 2014 on the same server.
D.
Perform an in-place upgrade of the SSRS environment.
Explanation:
We cannot do a side-by-side installation (answer C) because that’s not supported in
SharePoint mode so an in-place upgrade is the only option that doesn’t require additional
servers.
SQL Server 2014 Reporting Services (SSRS) Native mode can be installed side-by-side with
a SQL Server 2012 Native mode deployment.
There is no support for side-by-side deployments of SQL Server 2014 Reporting Services
(SSRS) SharePoint mode and any previous versions of SharePoint mode components.
Option D: In-place upgrade is possible since the mode remains the same.
seems wrong answer, compared to Q44
Agree with Jerry. Besides, the explanation seems wrong.
According to this article:
https://msdn.microsoft.com/en-us/library/ms143747(v=sql.120)
SSRS in SharePoint allows in-place but with downtime of Sharepoint server. In the chapter on SSRS 2012 to 2014 is the following statement: “SharePoint 2010: In-place upgrade of Reporting Services is supported but the upgrade scenario does require down time of the SharePoint environment..”.
I would go for C.
D
https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/upgrade-and-migrate-reporting-services
SQL Server 2016 Reporting Services (SSRS) Native mode can be installed side-by-side with a SQL Server 2012 or SQL Server 2014 Native mode deployment.
There is no support for side-by-side deployments of SQL Server 2016 Reporting Services (SSRS) SharePoint mode and any previous versions of Reporting Services SharePoint mode components.
D is correct
https://technet.microsoft.com/en-us/library/ms143747(v=sql.110).aspx