Trouble Spots
As with any exam, it will vary from person to person as to what is deemed to be difficult. Be sure you are familiar with each of the topics in the exam objectives listed below. You will need to have familiarity with the menu structures of SQL Server 2008 and knowledge of how to set filters.
Some of the types of questions you may see on the exam are outlined below:
Question 1. If you are involved with a company where the generation of reports has a higher priority than the ETL process, you should use which of the following:
Data Collector
Resource Governor
Facet
ETL Process Management
The answer to the above question is Resource Governor.
Question 2. To what file should you add a custom application setting if you want it to use the ReportViewer Web server control?
Enterprise.config
Machine.config
Web.config
Rviewer.config
The answer to the above question is Web.config.