70-465 Question #166: Real Exam Question with Answer & Explanation

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.

Explanation

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

Common mistakes.

• A. 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.
• C. 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.
• D. 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

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

No community discussion yet for this question.