Today I got the exam 70-442: PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005. I passed with a score 980 / 1000. It’d be nice if I were able to see my incorrect answer…
Anyways, here are my recommendations to the ones preparing for getting this exam soon:
There were 55 questions and 7 testlets again as usual (for North America). Namely, those testlets are
- Tailspin Toys
- Margie’s Travel
- Consolidated Messenger (asked twice with different set of questions)
- Contoso Ltd.
- Woodgrove Bank
- Choice Part
I want to mention about some keywords you need to know while dealing with those questions in the exam.
As for Tailspin Toys, make sure you understand the meaning and usage of the terms: DataSet, Read Committed, MARS.
For Margie’s Travel, the keywords are ‘set operations’, DataSet ( again ), Repeatable Read, Data Reader.
For Consolidated Messenger (my favorite one ) : Read Committed Snapshot, Keyset ( I strongly recommend you to fully understand Cursor options ), MARS, Data Reader, XML Reader.
For Contoso Ltd. : MARS, READPAST, Snapshot Isolation Level, Data Reader.
For the multiple choice part: RANK, CTEs (recursive stuff , especially for hierarchical reporting in a single table if the columns are refering to each other. Since CTE is an important concept, understand where it is used and try to write one on your own. ), XML functions like .exist, .value, .nodes, Cursor types (Static, Dynamic, Keyset, …), CUBE, PIVOT, PERCENT, LEFT OUTER JOIN, RIGHT OUTER JOIN, CROSS APPLY, CONTAINS …
Hope you also get a good exam experience..