Microsoft
70-246 · Question #124
70-246 Question #124: Real Exam Question with Answer & Explanation
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?
Exhibits
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
Explanation
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.
Common mistakes.
- A. 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.
- B. Advanced cluster preparation is specific to SQL Server failover cluster instance setup and is not applicable to stand-alone instance template creation.
- D. 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
Community Discussion
No community discussion yet for this question.