Microsoft
70-457 · Question #120
70-457 Question #120: Real Exam Question with Answer & Explanation
The correct answer is C. Restart the SQL Server Service. D. Add the CONTOSO\SQLService account to the Perform Volume Maintenance Tasks local security policy.. See the full explanation below for the reasoning.
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.
Community Discussion
No community discussion yet for this question.