70-448 : MCTS/MCITP/MCSA - Business Intelligence Development Using SQL Server 2008

Retired. This product is no longer available.

The MCSA: SQL Server 2008, Business Intelligence Development and Maintenance certification is an industry recognized credential. The certification is proof of a person's competence across a spectrum of skills which includes working with the Microsoft .NET Framework, using SQL Server 2005 and 2008, using Microsoft SQL Server Management Studio and many more.
55
70-448
MCTS/MCITP/MCSA - Business Intelligence Development Using SQL...

Here's what you will get

The MCSA: SQL Server 2008, Business Intelligence Development and Maintenance is part of MicrosoftÂ’s MCSA certification which comprises of two exams. It is a required part to the certification.

The certification is targeted at professionals who are involved with creating business intelligence (BI) solutions by using SQL Server 2008 for their organizations. Candidates typically work with the full suite of BI technologies in SQL Server 2008, including Reporting Services, Analysis Services, and Integration Services.

Lessons
Lessons
6+
Exercises
250+
Quizzes
128+
Flashcards
324+
Glossary of terms
324+
TestPrep
Pre-assessment Questions
15+
Full Length Tests
5+
Post-Assessment Questions
45+
Exam FAQs
What is the exam registration fee? USD 150
Where do I take the exam?

The Microsoft 70-448 exam is administered by Prometric and Pearson VUE at testing centers worldwide.

  • For Pearson VUE: Click here to find a testing center near you.
  • For Prometric: Click here to find a testing center near you.
What is the format of the exam? The exam consists of case study, simulations, virtual labs and question types consists of multiple-choice, hot-area, active-screen, drag-and-drop, build-list and reorder questions.
What are the pre-requisites of the exam? There are no technical pre-requisites for this certification.
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the duration of the exam? 120 minutes
What is the passing score? 700

(on a scale of 0-1000)

What is the exam's retake policy?

In the event that you fail your first attempt at passing the 70-448 exam, Microsoft's retake policy is:

  • If a candidate does not achieve a passing score on an exam the first time, the candidate must wait at least a 24-hour period before retaking the exam.
  • If a candidate does not achieve a passing score the second time, the candidate must wait at least a 14-day period before retaking the exam a third time.
  • A 14-day waiting period will also be imposed for the fourth and fifth subsequent exam retakes. A candidate may not take a given exam any more than five times per year (12 months). This 12-month period would start the day of the fifth unsuccessful exam retake. The candidate would then be eligible to retake the exam 12 months from that date. In order to take a given exam more than five times per year, a candidate must submit a request and obtain prior permission from Microsoft.
  • If a candidate achieves a passing score in an exam, the candidate cannot take it again.
What is the validity of the certification? Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification has no expiration. The certification holder is certified for life unless the vendor changes their policy. Click here for more information.
Where can I find more information about this exam? To know more about the 70-448, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?

A MCSA: SQL Server 2008, Business Intelligence Development and Maintenance certification has several career opportunities open up to them, including:

  • Database Developer
  • Database Administrator
  • Database Expert

Here's what you will learn

  • Implement control flow.
  • Implement data flow.
  • Implement dynamic package behavior by using property expressions.
  • Implement package logic by using variables.
  • Implement package configurations.
  • Implement auditing, logging, and event handling.
  • Extend SSIS packages by using .NET code.
  • Install and maintain SSIS components.
  • Deploy an SSIS solution.
  • Manage SSIS package execution.
  • Configure SSIS security settings.
  • Identify and resolve issues related to SSIS solution deployment.
  • Implement dimensions in a cube.
  • Implement measures in a cube.
  • Implement a data source view.
  • Configure dimension usage in a cube.
  • Implement custom logic in a cube by using MDX.
  • Implement data mining.
  • Implement storage design in a cube.
  • Configure permissions and roles in SSAS.
  • Deploy SSAS databases and objects.
  • Install and maintain an SSAS instance.
  • Diagnose and resolve performance issues.
  • Implement processing options.
  • Implement report data sources and datasets.
  • Implement a report layout.
  • Extend an SSRS solution by using code.
  • Create an SSRS report by using an SSAS data source.
  • Implement report parameters.
  • Implement interactivity in a report.
  • Implement report items.
  • Embed SSRS reports in custom applications.
  • Configure report execution and delivery.
  • Install and configure SSRS instances.
  • Configure authentication and authorization for a reporting solution.
  • Deploy an SSRS solution.
  • Configure SSRS availability.
  • DOWNLOADcourse outline
  • INSTRUCTOR ?free evaluation copy
  • Download Course Outline 70-448
  • Request for free evaluation copy for MCTS/MCITP/MCSA - Business Intelligence Development Using SQL Server 2008
  • Rating :
    (16)

    Customer Testimonials

    excellent
    Just to let you know I just passed on my exam.
    Your product is good specially due to having the study material integrated.
    Mike
    best
    Just wanted to say thank you for the great tool to help me pass . I can say with no hesitation that your tool assisted me greatly in not only learning some of the content but most importantly the pattern / method of answers required to pass. There where WAY too many questions that I could answered in any 2 or 3 ways but uCertify taught me the way to answer. I did not have a SINGLE question that was replicated AT ALL in the exam itself. I focused on taking your tests in "learn mode" and ensured I got the rest of information pertaining to the question which you supplied and this information was invaluable. The looks I got when I said I was a "self Study" actually made me feel guilty ... kinda! I am going to get this tool for the rest of my team for their next certification! Well done uCertify !
    Donald