70-764 Real Question Answers

1
Download Latest 70-764 Brain dumps
http//bit.ly/2qhv9mi
2
Description

• 70-764dumps PDF an easiest way for the solution
  of cisco 70-764 certification exam. It has
  updated and relevant study guide material which
  is useful for you for the preparation of
  70-764exams. Follow this link and prepare all
  question answers to clear exam in first attempt.
• http//www.dumps4certs.com/exam/70-764.html

3
Question 1

• You administer a Microsoft SQL Server 2012
  instance. You need to stop a blocking process
  that has an SPID of 64 without stopping other
  processes. What should you do?
• A. Execute the following Transact-SQL statement
  ALTER SESSION KILL '64'
• B. Execute the following Transact-SQL statement
  KILL 64
• C. Restart the SQL Server service.
• D. Execute the following Transact-SQL
• Answer B
• http//www.dumps4certs.com/exam/70-764.html

4
Question 2

• You administer a Microsoft SQL Server 2012
  server. When transaction logs grow, SQL Server
  must send an email message to the database
  administrators. You need to configure SQL Server
  to send the email messages. What should you
  configure?
• A. SQL Mail
• B. An Extended Events session
• C. Alerts and operators in SQL Server Agent
• D. Policies under Policy-Based Management
• Correct Answer C
• http//www.dumps4certs.com/exam/70-764.html

5
Question 3

• You administer a Microsoft SQL Server 2012
  database named Contoso on a server named
  Server01. You need to write messages to the
  Application Log when users are added to or
  removed from a fixed server role in Server01.
  What should you create?
• A. a Database Audit Specification
• B. a Policy
• C. an Alert
• D. a SQL Profiler Trace
• E. a Resource Pool
• F. an Extended Event session
• G. a Server Audit Specification
• Correct Answer G
• http//www.dumps4certs.com/exam/70-764.html

6
Thanks For Watching

• For more detail just visit
• http//www.dumps4certs.com/exam/70-764.html