AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Microsoft- 70-462





Question ID 18817

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.

Option A

Restart the SQL Server Agent Service.

Option B

Disable snapshot isolation.

Option C

Restart the SQL Server Service.

Option D

Add the CONTOSO\SQLService account to the Perform Volume Maintenance Tasks local security policy.

Option E

 Add the CONTOSO\SQLService account to the Server Operators fixed server role.

Option F

Answer : C,D

Explanation: Explanation/Reference: 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.

Correct Answer F
Explanation


Question ID 18818

You are the lead database administrator (DBA) of a Microsoft SQL Server 2012
environment.
All DBAs are members of the DOMAIN\JrDBAs Active Directory group. You grant
DOMAIN\JrDBAs access to the SQL Server.
You need to create a server role named SpecialDBARole that can perform the following
functions:
✑ View all databases.
✑ View the server state.
✑ Assign GRANT, DENY, and REVOKE permissions on logins.
You need to add DOMAIN\JrDBAs to the server role. You also need to provide the least
level of privileges necessary.
Which SQL statement or statements should you use? Choose all that apply.

Option A

 CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION setupadmin;

Option B

ALTER SERVER ROLE [SpecialDBARole] ADD MEMBER [DOMAIN\JrDBAs];

Option C

CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION securityadmin;

Option D

GRANT VIEW DEFINITION TO [SpecialDBARole];

Option E

CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION serveradmin;

Option F

GRANT VIEW SERVER STATE, VIEW ANY DATABASE TO [SpecialDBARole];

Correct Answer B,C,F
Explanation

Send email to admin@getfreedumps for new dumps request!!!