Home > Articles > Microsoft > MCTS

Exam Profile MCTS 70-448: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

  • Print
  • + Share This
This article profiles the Microsoft SQL Server 2008, Business Intelligence Development and Maintenance (MCTS 70-448), meant to be taken by those who are responsible for creating business intelligence (BI) solutions by using Microsoft SQL Server 2008 for their organizations. Pearson IT Certification provides a variety of exam preparation tools to help our customers in their quest for certification. As part of our service to you, we have developed this Exam Profile series. Each profile is developed based on the testing experience of one of our trainers or authors. You won’t get exact questions or answers, but you will get a real feel for the exam. Each profile describes question forms, trouble spots, hints for exam preparation, and recommendations for additional study resources. Find out what you can expect to see on the exam and how you can better prepare for it.

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.

Exam Details

  • 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
  • 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.

  • Time Limit: 120 minutes
  • How to Register: You can register for the exam at Prometric.com
  • + Share This
  • 🔖 Save To Your Account

Related Resources

There are currently no related titles. Please check back later.