Difficult areas for this exam will depend on the candidate’s experience with the different areas of SQL administration. One trouble spot most SQL administrators may hit is transactional administration. Microsoft GUI’s are so good, we often neglect the Transact-SQL Syntax Conventions of administration. I strongly recommend candidates review the T-SQL conventions related to the exam objectives listed on page 2 of this article. T-SQL will probably not be the majority of your exam, but will be significant enough that ignoring it could be detrimental to your testing experience.