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

Administering Microsoft SQL Server 2012 Databases

Question No: 81 DRAG DROP – (Topic 2)

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.)

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

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.

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

->Create an audit and define the target.

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

->Enable the audit.

->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(v=sql.110).aspx https://msdn.microsoft.com/en-us/library/cc280663(v=sql.110).aspx

Question No: 82 – (Topic 2)

What is the maximum number of SQL Server 2012 Enterprise edition Database Engine instances that you can deploy on a non-clustered server running Windows Server 2008 R2 Enterprise edition?

  1. 10

  2. 25

  3. 50

D. 100

Answer: C

Question No: 83 – (Topic 2)

If you find that session ID 42 is blocking several other sessions, which of the following will kill that session?

  1. REMOVE 42;

  2. TERMINATE 42;

  3. KILL SESSION 42;

  4. KILL 42;

Answer: D

Explanation: References

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

Question No: 84 – (Topic 2)

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

You need to ensure that data can be migrated from a production server to two reporting servers with minimal data to ensure that data on the reporting server is always accessible which solution should you use?

  1. Database snapshot

  2. Log Shipping

  3. Change Data Capture

  4. Availability Groups

Answer: D

Question No: 85 – (Topic 2)

You have recently removed a SQL 2012 Database Engine instance from a computer running the Windows Server 2008 R2 operating system. Prior to the removal of the instance, you had configured affinity so that the default instance used CPU 0 and 1 and the second instance used CPU 2 and 3.

You want to ensure that the default instance can use all processors available to the host. Which of the following commands would you use to accomplish this goal?

  1. ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = AUTO

  2. ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 2,3

  3. ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 0,1

  4. ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 0,4

Answer: A

Question No: 86 – (Topic 2)

You have been hired as a Database Consultant by ABC.com to design a SQL Server 2012 database solution.

You are tasked with designing a scale-out and high-availability SQL Server 2012 Online

Transaction Processing (OLTP) database solution that will maintain copies of data across two server instances.

Your solution must provide scale-out of read operations by distributing the reads from clients across two SQL Server 2012 nodes. The data in both SQL Server nodes needs to be indexed.

What should you include in your solution?

  1. You should include a primary database with scheduled log shipping to the secondary database configured.

  2. You should include two servers configured in an Active-Passive SQL Server 2012 Cluster.

  3. You should include a primary SQL Server 2012 database that uses transactional replication to replicate data to the secondary database.

  4. You should include two servers in an Asynchronous-Commit Availability Mode Availability Group.

  5. You should include two servers in a Synchronous-Commit Availability Mode Availability Group.

Answer: C

Question No: 87 – (Topic 2)

You administer a SQL Server 2012 server that contains a database named SalesDB. SalesDb contains a schema named Customers that has a table named Regions. A user named UserA is a member of a role named Sales.

UserA is granted the Select permission on the Regions table and the Sales role is granted the Select permission on the Customers schema.

You need to ensure that the Sales role, including UserA, is disallowed to select from the Regions table.

Which Transact-SQL statement should you use?

  1. REVOKE SELECT ON Schema::Customers FROM UserA

  2. REVOKE SELECT ON Object::Regions FROM UserA

  3. EXEC sp_addrolemember #39;Sales#39;, #39;UserA#39;

  4. DENY SELECT ON Schema::Customers FROM Sales

  5. EXEC sp_droprolemember #39;Sales#39;, #39;UserA#39;

  6. REVOKE SELECT ON Schema::Customers FROM Sales

  7. DENY SELECT ON Object::Regions FROM UserA

  8. REVOKE SELECT ON Object::Regions FROM Sales

  9. DENY SELECT ON Schema::Customers FROM UserA

  10. DENY SELECT ON Object::Regions FROM Sales

Answer: J Explanation: References:

http://msdn.microsoft.com/en-us/library/ms188369.aspx http://msdn.microsoft.com/en-us/library/ms187750.aspx http://msdn.microsoft.com/en-us/library/ff848791.aspx

Question No: 88 – (Topic 2)

You administer a Microsoft SQL Server 2012 database.

Users report that an application that accesses the database displays an error, but the error does not provide meaningful information. No entries are found in the SQL Server log or Windows event logs related to the error.

You need to identify the root cause of the issue by retrieving the error message. What should you do?

  1. Update all stored procedure to use a TRY…CATCH block.

  2. Create a SQL Profiler session to capture all ErrorLog and EventLog events.

  3. Flag all stored procedures for recompilation by using sp_recompile.

  4. Execute sp_who.

Answer: A

Question No: 89 – (Topic 2)

Which of the following is required in order for a differential backup to be useful for recovery purposes?

  1. A full backup taken previous to the differential backup.

  2. Hard drive space that is 2 times the size of the database you want to restore.

  3. Less than 1000 database transactions an hour.

  4. A full backup taken after the differential backup.

Answer: A

Explanation: References:

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

Question No: 90 HOTSPOT – (Topic 2)

You administer a Microsoft SQL Server 2012 instance.

You need to configure an existing SQL Authenticated Login that meets the following requirements:

->Enforces password policy

->No password expiration enforcement

->Resets the default database to AdventureWorks database

Which option or options should you choose in the Login Properties of the login for User1? (To answer, configure the appropriate option or options in the dialog box in the answer areA. )

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

100% Dumps4cert Free Download!
Download Free Demo:70-462 Demo 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