Provisioning SQL Databases — Question 68

You administer a Microsoft SQL Server 2012 server. The MSSQLSERVER service uses a domain account named CONTOSO\SQLService.
You plan to configure Instant File Initialization.
You need to ensure that Data File Autogrow operations use Instant File Initialization.
What should you do? Choose all that apply.

Answer options

• A. Restart the SQL Server Agent Service.
• B. Disable snapshot isolation.
• C. Restart the SQL Server Service.
• D. Add the CONTOSO\SQLService account to the Perform Volume Maintenance Tasks local security policy.
• E. Add the CONTOSO\SQLService account to the Server Operators fixed server role.
• F. Enable snapshot isolation.

Correct answer: C, D

Explanation

To allow Instant File Initialization for Data File Autogrow, the SQL Server service must be restarted (option C) after granting the necessary permissions. Adding the CONTOSO\SQLService account to the Perform Volume Maintenance Tasks local security policy (option D) is required for allowing the service to perform the necessary volume operations. The other options do not directly contribute to enabling Instant File Initialization.