Yes, the training kit would be enough to pass the exam.

However, you will have to practice with SQL Queries a lot if you are new to TSQL.

Regarding XML, don't fear, after studying you will love to use XML with SQL. For XML prep you can refer to this MSDN article: https://msdn.microsoft.com/en-IN/library/ms190922.aspx