Exam Profile MCITP 70-452: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008
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:
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?
The answer to the above question is Web.config.