Valid 70-462 Dumps shared by NewPassLeader for Helping Passing 70-462 Exam! NewPassLeader now offer the newest 70-462 exam dumps, the NewPassLeader 70-462 exam questions have been updated and answers have been corrected get the newest NewPassLeader 70-462 dumps with Test Engine here:

http://https://www.newpassleader.com/Microsoft/70-462-exam-preparation-materials.html (302 Q&As Dumps, 30%OFF Special Discount: 30free )

NEW QUESTION NO: 8

You are a database administrator for a Microsoft SQL Server 2012 instance.

You need to ensure that data can be replicated from a production server to two reporting servers in real time.

You also need to ensure that data on the reporting server is always accessible.

Which solution should you use?

A. Availability Groups

B. Extended Events

C. Snapshot Replication

D. Policy Based Management

Answer: A

Explanation/Reference:

Explanation:

The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012, AlwaysOn Availability Groups maximizes the availability of a set of user databases for an enterprise. An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of read-write primary databases and one to four sets of corresponding secondary databases. Optionally, secondary databases can be made available for read- only access and/or some backup operations.

An availability group fails over at the level of an availability replica. Failovers are not caused by database issues such as a database becoming suspect due to a loss of a data file, deletion of a database, or corruption of a transaction log.

References: https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/hh510230(v=sql.110)



NEW QUESTION NO: 9

You administer a Microsoft SQL Server 2012 database.

The database contains a customer table created by using the following definition:



You need to ensure that the minimum amount of disk space is used to store the data in the customer table.

What should you do?

A. Convert all indexes to Column Store indexes.

B. Implement row-level compression.

C. Implement Unicode compression.

D. Implement page-level compression.

Answer: D



NEW QUESTION NO: 10

You administer two Microsoft SQL Server 2012 servers named ProdSrv1 and ProdSrv2.

ProdSrv1 is configured as a Distributor.

Both servers are configured to use the Windows NT Service virtual accounts for all SQL Services.

You are configuring snapshot replication from ProdSrv1 to ProdSrv2 by using ProdSrv2 as a pull subscriber.

The distribution agent on ProdSrv2 regularly fails, displaying the following error message:

"Cannot access the file. Operating system error code 5 (Access is denied.)." You need to configure the distribution agent by granting only the minimum required access to all accounts.

What should you do?

A. Configure the SQL Server service on ProdSrv2 to use the Local System account.

B. Configure the Subscriber to use a Windows domain account. Grant READ access for the domain account to the ReplData share on ProdSrv1.

C. Grant EXECUTE permission on xp_cmdshell to the [NT SERVICE\SQLSERVERAGENT] account.

D. Configure the SQL Server Agent service to run under a Windows domain account. Configure the Subscriber to use the SQL Server Agent service account. Grant EXECUTE permissions on xp_cmdshell to the Windows domain account.

Answer: B



NEW QUESTION NO: 11

DRAG DROP

You administer a Microsoft SQL Server database. Service accounts for SQL Agent are configured to use a local user.

A Microsoft SQL Server Integration Services (SSIS) job step has been created within a SQL Server Agent job.

The SSIS package accesses a network share when exporting data from a SQL Server database.

When you execute the SQL Server Agent job, it fails due to a permissions failure on a share on a remote server.

You need to ensure that the SQL Server Agent job can execute the SSIS package.

Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.) Select and Place:



Answer: 



Explanation/Reference:

Explanation:

SQL Server Agent allows creating a proxy account which defines the security context for the job step.

We need to do is to create a credential to be used by the proxy account.

The created proxy need to have access to the SSIS subsystem

References: https://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent- using-a-proxy-account/



NEW QUESTION NO: 12

DRAG DROP

You administer several Microsoft SQL Server 2012 servers.

You want to run scheduled checks to confirm that the databases on the servers are not configured to AutoShrink.

You need to create a policy to check the condition.

What should you do? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.) Select and Place:



Answer: 



Explanation/Reference:

Explanation:

The Evaluation Mode defines the combination of 1) when the policy will be evaluated and 2) what the system will do in case of policy violation. The following evaluation modes are supported:



References: https://blogs.msdn.microsoft.com/sqlpbm/2009/04/13/policy-evaluation-modes/



NEW QUESTION NO: 13

Which of the following is a prerequisite for an SQL Server 2012 installation?

A. .NET Framework 3.5 SP1

B. Visual Basic 6

C. Internet Explorer 10

D. SQL Server Integration Services

Answer: A

Explanation/Reference:

References:

https://msdn.microsoft.com/en-us/library/ms143506%28v=sql.110%29.aspx



NEW QUESTION NO: 14

DRAG DROP

You administer a Microsoft SQL Server database.

You want to import data from a text file to the database.

You need to ensure that the following requirements are met:

Data import is performed by using a stored procedure.



Data is loaded as a unit and is minimally logged.



Which data import command and recovery model should you choose? (To answer, drag the appropriate data import command or recovery model to the appropriate location or locations in the answer area. Each data import command or recovery model may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.) Select and Place:



Answer: 





NEW QUESTION NO: 15

DRAG DROP

You administer a Microsoft SQL Server 2012 database named Human_Resources.

You need to ensure that all read activity against any object in the Human_Resources database is audited and written to a text file.

What should you do? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.) Select and Place:



Answer: 



Explanation/Reference:

Explanation:

Create a new Audit. For destination, select File.

Create a new Database Audit Specification on Human_Resources. For Audit Action Type, select Select, and for Object Class, select Database.

Enable Audi and Audi Specification.

Explanation:

The general process for creating and using an audit is as follows.

1. Create an audit and define the target.

2. Create either a server audit specification or database audit specification that maps to the audit. Enable the audit specification.

3. Enable the audit.

4. Read the audit events by using the Windows Event Viewer, Log File Viewer, or the fn_get_audit_file function.

References:

https://msdn.microsoft.com/en-us/library/cc280386%28v=sql.110%29.aspx

https://msdn.microsoft.com/en-us/library/cc280663%28v=sql.110%29.aspx



NEW QUESTION NO: 16

You are the lead database administrator (DBA) of a Microsoft SQL Server 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 three SQL statements should you use? Each correct answer presents part of the solution.

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

B. CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION sysadmin;

C. CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION securityadmin;

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

E. GRANT VIEW ANY DATABASE TO [SpecialDBARole];

F. CREATE SERVER ROLE [SpecialDBARole];

Answer: A,C,D



NEW QUESTION NO: 17

DRAG DROP

You are a database administrator of a Microsoft SQL Server 2012 environment. The environment contains two servers named SQLServer01 and SQLServer02. The database Contoso exists on SQLServer01.

You plan to mirror the Contoso database between SQLServer01 and SQLServer02 by using database mirroring.

You need to prepare the Contoso database for database mirroring.

Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.) Select and Place:



Answer: 



Explanation/Reference:

Reference:

http://msdn.microsoft.com/en-us/library/ms190941.aspx

http://msdn.microsoft.com/en-us/library/ms189852.aspx



NEW QUESTION NO: 18

You administer a Microsoft SQL Server instance.

You need to configure a new database to support FILETABLES.

Which three actions should you perform? Each correct answer presents part of the solution.

A. Disable FILESTREAM on the Database.

B. Enable FILESTREAM on the Server Instance.

C. Configure the Database for Partial Containment.

D. Create a non-empty FILESTREAM file group.

E. Enable Contained Databases on the Server Instance.

F. Set the FILESTREAM directory name on the Database.

Answer: B,D,F

Explanation/Reference:

Reference: http://msdn.microsoft.com/en-us/library/gg509097.aspx