Microsoft
70-457 · Question #120
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…
Sign in or unlock 70-457 to reveal the answer and full explanation for question #120. The question stem and answer options stay visible for context.
Question
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.
Options
- ARestart the SQL Server Agent Service.
- BDisable snapshot isolation.
- CRestart the SQL Server Service.
- DAdd the CONTOSO\SQLService account to the Perform Volume Maintenance Tasks local security policy.
- EAdd the CONTOSO\SQLService account to the Server Operators fixed server role.
- FEnable snapshot isolation.
Unlock 70-457 to see the answer
You've previewed enough free 70-457 questions. Unlock 70-457 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.