Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Aug Microsoft Official New Released 70-462
100% Free Download! 100% Pass Guaranteed!

Administering Microsoft SQL Server 2012 Databases

Question No: 101 – (Topic 2)

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.

You need to track all SELECT statements issued in the Contoso database only by users in a role named Sales.

What should you create?

  1. An Alert

  2. A Resource Pool

  3. An Extended Event session

  4. A Server Audit Specification

  5. A SQL Profiler Trace

  6. A Database Audit Specification

  7. A Policy

  8. A Data Collector Set

Answer: F

Question No: 102 – (Topic 2)

You administer a Microsoft SQL Server 2012 database that contains a table named AccountTransaction.

You discover that query performance on the table is poor due to fragmentation on the

IDX_AccountTransaction_AccountCode non-clustered index.

You need to defragment the index. You also need to ensure that user queries are able to use the index during the defragmenting process.

Which Transact-SQL batch should you use?

  1. ALTER INDEX IDX_AccountTransaction_AccountCode ON AccountTransaction.AccountCode REORGANIZE

  2. ALTER INDEX ALL ON AccountTransaction REBUILD

  3. ALTER INDEX IDX_AccountTransaction_AccountCode ON AccountTransaction.AccountCode REBUILD

  4. CREATE INDEX IDXAccountTransactionAccountCode ON AccountTransaction.AccountCode WITH DROP EXISTING

Answer: A

Question No: 103 – (Topic 2)

You have configured Resource Governor with three resource pools.

You have assigned the first resource pool a minimum CPU and memory value of 20%. You have assigned the second resource pool a minimum CPU and memory value of 30%. You want to assign maximum CPU and memory values to the third resource pool.

What is the maximum CPU and memory value you can assign to this resource pool?

A. 30%

B. 50%

C. 70%

D. 100%

Answer: B

Question No: 104 DRAG DROP – (Topic 2)

You administer a Microsoft SQL Server 2012 database instance that uses transparent database encryption.

You plan to move the database from the current server to a new server by using Backup and Restore.

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Explanation:

Backup the Private Key Backup the Database Restore the Private Key Restore the Database

References:

http://sqlsailor.com/2011/12/29/tdetransparent-data-encryption-in-sql-server-2012-rc-0/

Question No: 105 – (Topic 2)

Which of the following statements about the tempdb system database is FALSE?

  1. It is a globally available resource for all connected users.

  2. It can hold explicitly or implicitly created database objects.

  3. It must be sized in accordance with the smallest user-database on the machine.

  4. It is created every time the SQL Server instance is restarted.

Answer: C

Explanation: References:

https://msdn.microsoft.com/en-us/library/ms190768(v=sql.110).aspx

Question No: 106 – (Topic 2)

You administer a SQL Server 2012 database instance.

You need to configure the SQL Server Database Engine service on a failover cluster. Which user account should you use?

  1. A domain user

  2. The BUILTIN\SYSTEM account

  3. A local user with Run as Service permissions

  4. TheSQLBrowser account

Answer: A

Question No: 107 – (Topic 2)

Which of the following is a high availability feature with SQL Server 2012?

  1. Clustering

  2. AlwaysOn

  3. Log Shipping

  4. Active-Active

Answer: B

Explanation: References:

https://msdn.microsoft.com/en-us/library/ms190202(v=sql.110).aspx

Question No: 108 – (Topic 2)

Which of the following is a disaster recovery solution offered in SQL Server 2012 and involves maintaining a standby copy of a primary database?

  1. AlwaysOn

  2. Log Shipping

  3. Clustering

  4. DataGuard

Answer: A

Question No: 109 – (Topic 2)

You administer a Microsoft SQL Server 2012 failover cluster.

You need to ensure that a failover occurs when the server diagnostics returns query_processing error.

Which server configuration property should you set?

  1. SqlOumperDumpFlags

  2. FailureConditionLevel

  3. HealthCheckTimeout

  4. SqlDumperDumpPath

Answer: B

Question No: 110 – (Topic 2)

Which of the following is NOT a pre-defined server role in SQL Server 2012?

  1. securityadmin

  2. serveradmin

  3. sysdba

  4. dbcreator

Answer: C

Explanation: References:

https://msdn.microsoft.com/en-us/library/ms188659(v=sql.110).aspx

100% Dumps4cert Free Download!
70-462 PDF
100% Dumps4cert Pass Guaranteed!
70-462 Dumps

Dumps4cert ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.