Download Microsoft.70-462.Prep4Sure.2018-06-15.176q.tqb
| Vendor: | Microsoft |
| Exam Code: | 70-462 |
| Exam Name: | Administering Microsoft SQL Server 2012/2014 Databases |
| Date: | Jun 15, 2018 |
| File Size: | 4 MB |
Demo Questions
Question 1
You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.
You need to diagnose deadlocks that happen when executing a specific set of stored procedures by recording events and playing them back on a different test server.
What should you create?
- An Extended Event session
- A Policy
- A Database Audit Specification
- An Alert
- A Server Audit Specification
- A SQL Profiler Trace
- A Resource Pool
Correct answer: F
Explanation:
Reference: http://msdn.microsoft.com/en-us/library/ms188246.aspx Reference: http://msdn.microsoft.com/en-us/library/ms188246.aspx
Question 2
You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.
You need to prevent users from disabling server audits in Server01.
What should you create?
- An Alert
- A Resource Pool
- An Extended Event session
- A Policy
- A Database Audit Specification
- A SQL Profiler Trace
- A Server Audit Specification
Correct answer: D
Question 3
You administer a Microsoft SQL Server 2012.
A process that normally runs in less than 10 seconds has been running for more than an hour.
You examine the application log and discover that the process is using session ID 60.
You need to find out whether the process is being blocked.
Which Transact-SQL statement should you use?
- SELECT * FROM sys.dm_exec_requests WHERE session_id = 60
- SELECT * FROM sys.dm_exec_sessions WHERE session_id = 60
- DBCC INPUTBUFFER (60)
- DBCC OPENTRAN
Correct answer: A
