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.
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.
Explanation:
http://msdn.microsoft.com/en-us/library/ms175935.aspx
http://www.mssqltips.com/sqlservertip/2752/effect-of-instant-file-initialization-within-sql-server/
How To Enable Instant File Initialization
1. Open Local Security Policy and go to Local Policies –> User Rights Assignment.2. Double click Perform Volume Maintenance Tasks and add your SQL Server database engine
service account.
3. Restart the SQL Server service using SQL Server Configuration Manager and this setting should
now be enabled.
C – D
C D
Whenever SQL Server allocates space disk to create/restore a database or grow data/log files he fills first the files of the allocated space with “0” before using it.
Instant File Initialization allows you to skip that phase(fill with “0”)
To perform IFI we:
**add security account to “Perform
Maintenance Volume Tasks” of the Windows
Local Security Policy
**Restart SQL Server Service
HENCE THE ANSWER D,C