Exam 70-765 topic 3 question 16 discussion

Actual exam question from Microsoft's 70-765

Question #: 16
Topic #: 3

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.

Show Suggested Answer

Suggested Answer: CD 🗳️
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.
References:
http://msdn.microsoft.com/en-us/library/ms175935.aspx

by jolsca at Sept. 8, 2020, 12:10 a.m.

Comments

Submit Cancel

jolsca

4 years, 10 months ago

Is Correct C and D You also needed to restart the SQL Server service in order for SQL Server to start using Instant File Initialization.

upvoted 1 times

...