Administering a SQL Database Infrastructure – Microsoft: 70-764 exam. Share the latest 70-764 dumps and Practice test questions for free. Real and effective exam questions and answers.70-764 pdf online Download, Examthings share 40 Practice test questions for FREE! Get the full 70-764 exam dumps: https://www.leads4pass.com/70-764.html (Total questions:380 Q&A)
[PDF] Free Microsoft MCSA 70-764 pdf dumps download from Google Drive: https://drive.google.com/open?id=10hn31bPob_2072mBH7U_7yOGGE02joOP
[PDF] Free Full Microsoft pdf dumps download from Google Drive: https://drive.google.com/open?id=1AwBFPqkvdpJBfxdZ3nGjtkHQZYdBsRVz
Exam 70-764: Administering a SQL Database Infrastructure – Microsoft: https://www.microsoft.com/en-us/learning/exam-70-764.aspx
Latest effective Microsoft MCSA 70-764 Exam Practice Tests
QUESTION 1
You have an SQL Server 2016 server named SQL1. You are designing a performance monitoring solution.
You need to monitor the following events on SQL1:
A deadlock graph Missing column statistics CPU performance statistics A batch of completed Transact-SQL statements
Which two tools should you use? Each correct answer presents a complete solution.
A. dynamic management views
B. Database Engine Tuning Advisor
C. SQL Server Profiler
D. Activity Monitor
E. Data Profile Viewer
Correct Answer: BC
Explanation: B: Database Engine Tuning Advisor examines how queries are processed in the databases you specify.
When you run a Profiler Trace and feed it to the Database Engine Tuning Advisor, it also looks for missing column
statistics, and it can automatically create them for you.
C: Use SQL Server Profiler to identify the cause of a deadlock. A deadlock occurs when there is a cyclic dependency
between two or more threads, or processes, for some set of resources within SQL Server. Using SQL Server Profiler,