Overview/Description
To monitor and resolve database blocks, and connect to the server using a dedicated administrator connection (DAC)
Target Audience
Professionals typically pursuing a career as a Database Administrator, Database Developer or Business Intelligence Developer; individuals who do not work with SQL Server as a part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators among others
Prerequisites
This is a high-level technical path and candidates for the exam, and hence learners should be expert in the following areas:
Tools usage
UI navigation
Wizards usage
Writing code in the appropriate language (Transact-SQL, CLR Language, other scripting languages, etc.)
Code debugging or syntactic issue resolution
Troubleshooting
Accomplishing specific focused tasks through the use of code or UI navigation