70-246 · Question #124
You are preparing a virtual machine that will be used as a template. You need to install SQL Server 2008 R2 on the virtual machine. The solution must meet the technical requirement for creating…
The correct answer is C. Image preparation of a stand-alone instance of SQL Server. SQL Server 2008 R2 introduced SysPrep support via 'Image preparation,' which installs SQL Server binaries without completing instance configuration, making the VM safe to capture as a template.
Question
You are preparing a virtual machine that will be used as a template. You need to install SQL Server 2008 R2 on the virtual machine. The solution must meet the technical requirement for creating virtual machines. Which SQL Server 2008 R2 installation option should you select?
Exhibit
Options
- AImage completion of a prepared stand-alone instance of SQL Server
- BAdvanced cluster preparation
- CImage preparation of a stand-alone instance of SQL Server
- DInstall based on configuration file
How the community answered
(40 responses)- B5% (2)
- C93% (37)
- D3% (1)
Why each option
SQL Server 2008 R2 introduced SysPrep support via 'Image preparation,' which installs SQL Server binaries without completing instance configuration, making the VM safe to capture as a template.
Image completion is the second phase of the SysPrep process - it finalizes a previously prepared SQL Server instance on a deployed VM and cannot be used on a template being prepared.
Advanced cluster preparation is specific to SQL Server failover cluster instance setup and is not applicable to stand-alone instance template creation.
Image preparation of a stand-alone instance runs the SQL Server setup in a two-phase SysPrep-compatible mode: the first phase installs binaries and records settings without finalizing the instance. This leaves the SQL Server installation in an unconfigured state so the VM can be generalized and captured as a template. When the template is later deployed, the image completion step finalizes the SQL Server instance with environment-specific settings.
Installing from a configuration file performs a full, immediate SQL Server installation and does not produce an unconfigured binary state suitable for VM template capture.
Concept tested: SQL Server 2008 R2 SysPrep image preparation for templates
Source: https://learn.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-using-sysprep
Topics
Community Discussion
No community discussion yet for this question.