nerdexam
Microsoft

70-465 · Question #166

You are planning an upgrade of 10 similarity configured servers that have SQL Server 2008 service pack 3 installed. The Server will be upgraded to SQL Server 2014. The upgraded Servers must include…

The correct answer is B. Create a slipstream installation of SQL Server 2014, and then install the slipstream version of Sql Server. This question tests knowledge of SQL Server upgrade paths and slipstream installations to minimize server downtime during upgrades with required hotfixes.

Submitted by renata2k· Mar 5, 2026Design and implement database solutions for SQL Server

Question

You are planning an upgrade of 10 similarity configured servers that have SQL Server 2008 service pack 3 installed. The Server will be upgraded to SQL Server 2014. The upgraded Servers must include 10 hotfixes indetify by your company's security team. You need to recommended a solution to upgrade the servers. The solution must minimize the amount of time the servers are unavailable. What sould you recommended?

Options

  • AInstall SQL Server 2012, install SQL Server 2014 and then install the hotfixes
  • BCreate a slipstream installation of SQL Server 2014, and then install the slipstream version of Sql Server
  • CCreate a slipstream installation of Sql Server 2014.
  • DInstall SQL Server 2008 R2, Install SQL Server 2014 and then install the hotfixes.

How the community answered

(50 responses)
  • A
    4% (2)
  • B
    78% (39)
  • C
    12% (6)
  • D
    6% (3)

Why each option

This question tests knowledge of SQL Server upgrade paths and slipstream installations to minimize server downtime during upgrades with required hotfixes.

AInstall SQL Server 2012, install SQL Server 2014 and then install the hotfixes

Installing SQL Server 2012 as an intermediate step before SQL Server 2014 is unnecessary for upgrading from SQL Server 2008 SP3, as a direct upgrade path to SQL Server 2014 exists, and this approach adds extra downtime with multiple installation phases.

BCreate a slipstream installation of SQL Server 2014, and then install the slipstream version of Sql ServerCorrect

Creating a slipstream installation integrates SQL Server 2014 with the required hotfixes into a single installation package, meaning the upgrade and all 10 hotfixes are applied in one pass. This minimizes downtime because administrators do not need to perform separate installation steps for the base product and each hotfix. A slipstream install reduces the total time servers are unavailable by combining everything into one streamlined deployment.

CCreate a slipstream installation of Sql Server 2014.

Creating a slipstream installation alone without actually deploying it does not complete the upgrade; the slipstream package must also be installed on the servers to achieve the upgrade and minimize downtime.

DInstall SQL Server 2008 R2, Install SQL Server 2014 and then install the hotfixes.

Installing SQL Server 2008 R2 as an intermediate step before SQL Server 2014, followed by separate hotfix installations, involves multiple sequential steps that significantly increase the total time the servers are unavailable compared to a slipstream approach.

Concept tested: SQL Server slipstream installation to minimize upgrade downtime

Source: https://learn.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-installation-wizard-setup

Topics

#SQL Server upgrade#Slipstream installation#Patch management#Downtime minimization

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-465 Practice