Exam Profile MCTS 70-448: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
The 70-448 exam is meant to be taken by those who are responsible for creating business intelligence (BI) solutions by using Microsoft SQL Server 2008 for their organizations. The prerequisites that Microsoft recommends for those who want to take this exam are:
- One to two years of experience working with the Microsoft .NET Framework
- Two to three years of experience using SQL Server 2005 BI components
- Six months to one year of experience using SQL Server 2008
- Experience using the SQL Server 2008 Business Intelligence Development Studio (BIDS)
- Experience using Microsoft SQL Server Management Studio (SSMS)
- Knowledge of relational and multi-dimensional database schemas
- Experience creating and deploying a cube in SQL Server Analysis Services (SSAS)
- Experience creating and deploying a data mining model in SSAS
- Experience writing relational and multi-dimensional database queries
- Experience creating and deploying SQL Server Reporting Services (SSRS) reports
- Experience authoring and deploying SQL Server Integration Services (SSIS) packages
- Experience debugging, monitoring, and troubleshooting BI solutions
After you pass the Microsoft SQL Server 2008, Business Intelligence Development and Maintenance exam 70-448, you will have completed the requirements for Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
- Number of Questions: Approximately 50 questions (Since Microsoft does not publish this information, the number of exam questions may change without notice.)
- Type of Questions: This test format is multiple choice.
- Passing Score: 700
- Time Limit: 120 minutes
- How to Register: You can register for the exam at Prometric.com
This passing score does not mean that you must answer 70 percent of the items correctly in order to pass the exam. The actual percentage varies from exam to exam and may be more or less than 70 percent. There is no penalty for guessing. No points are deducted for incorrect answers. If a question specifies that you must choose multiple correct answers, you must choose the exact number of correct answers specified in the question in order to earn a point for that item. Some of the questions on the exam may not count toward the calculation of your score. Microsoft will often throw a question in that is meant to gather data that will help them improve the exam.