DRAG DROP
You administer a Microsoft SQL Server 2012 database.
Your database is experiencing deadlock issues.
You need to be able to monitor deadlocks.
Which three actions should you perform in sequence? (To answer, move the appropriate actions
from the list of actions to the answer area and arrange them in the correct order.)
Get 50% Discount on All Your Purchases
at PrepAway.com - Latest Exam Questions
This is ONE TIME OFFER
50%
dbcc traceon (1221,-1) doesn’t exist. Maybe that’s why it isn’t the right answer. Otherwise, The benefit of using the -T startup option is that you can ensure the trace flag is enabled even if SQL Server gets restarted.
https://www.mssqltips.com/sqlservertip/2130/finding-sql-server-deadlocks-using-trace-flag-1222/
Which is so subtle, I don’t know who would be able to answer this question correctly without first seeing the question
0
0
2 – 5 – 3
0
0
Answer is correct
0
0
Check
https://technet.microsoft.com/en-us/library/ms178104(v=sql.105).aspx
0
0