I highly doubt you will pass this exam using this book alone. If you have SQL Server experience, or already passed 70228 you might, but this book misses out so much that you will need to do well on the exam. I had around 6 years experience with Databases (mostly Oracle and a little Sql Server), but it took me 2 attempts and I had to purchase a practise exam too. So this is one hard exam especially compared to 70315.
The book teaches you the basics but has problems - there is no author's website, some of the mistakes I saw make me think the author dictated it to someone and it was never proofread. The practice exam at the end just reuses questions from each chapter - how lazy of the author and the exam has 45 questions but only 44 answers. Part of it's target audience is those studying for MCAD, yet it doesn't include any information on installing SQL Server and setting up your databases, which MCAD students need as they won't have done 70228. The book doesn't come with examples on disc either so you will have to type everything. The section on ownership is short and confusing and in the end I had to build the example myself and experiment to work out what was going on. Considering it is a book about databases the index is lousy too - I doubt I ever easily found what I wanted via the index. The section on Full Text Searches only tells you it needs to be installed in the end of Chapter summary! By the way Full Text Search won't run on XP (the author doesn't tell you that either). The author tends to say everything twice and doesn't always explain topics properly e.g. normalization. The book includes no rules of thumb that are particularly useful for the exam.
Amit Kalani's books in the Que series are excellent, but this book is lousy and appears to have been rushed out and never been updated or supported.
It is difficult to find a recommended book for 70229, maybe Professional SQL Server 2000 Programming by R Viera would be a better buy.