What should you do?

You administer a Microsoft SQL Server 2016 server.

The MSSQLSERVER service uses a domain account named CONTOSOSQLService.

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 CONTOSOSQLService account to the Perform Volume Maintenance Tasks local security policy.
E . Add the CONTOSOSQLService account to the Server Operators fixed server role.
F . Enable snapshot isolation.

Answer: CD


How To Enable Instant File Initialization

Latest 70-764 Dumps Valid Version with 451 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>