70-442 : PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005

Retired. This product is no longer available.

The Microsoft Certified IT Professional: Database Administrator certification is an industry recognized vendor neutral credential. The certification is proof of a person's competence across a spectrum of skills including database administration, database development and application development.
16 16
PRO: Designing and Optimizing Data Access by Using Microsoft...

Here's what you will get

The PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 is part of Microsoft's MCITP which comprises of two exams. It is an optional piece to the certification. The certification is targeted at database administrators and database developers involved with installing or configuring Microsoft SQL Server 2005 and managing or maintaining databases or multidimensional databases. The exam covers network technologies, installation and configuration, media and topologies, management, and security.

Pre-assessment Questions
Full Length Tests
Post-Assessment Questions
Exam FAQs
What is the exam registration fee? 150
Where do I take the exam? The PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 is administered by Prometric at testing centers worldwide. Click here to find a testing center near you.
What are the pre-requisites of the exam?

While there are no official prerequisites to take the MCITP certification, both Microsoft and uCertify strongly recommend that the candidates for this exam should have expertise in the following areas:

  • Writing Transact-SQL queries
  • Programming databases
  • Troubleshooting programming objects (stored procedures, triggers, user-defined functions (UDFs), user-defined types (UDTs), and queries)
  • Performing database performance tuning and optimization
  • Designing databases, at both the conceptual and logical levels
  • Implementing databases at the physical level
  • Designing and troubleshooting the data access layer of the application
  • Gathering business requirements
How many questions are asked in the exam? The exam contains 50 questions.
What is the duration of the exam? 120 minutes
What is the passing score? 70%

(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 MCITP certification, Microsoft's retake policy is:

  • If a candidate does not achieve a passing score on an exam the first time, he 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.
What is the validity of the certification? MCITP 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-442, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?

A Microsoft MCITP certified professional has several career opportunities open up to them, including:

  • Database Developer
  • Database Administrator
  • Database Expert
  • Database Manager

Here's what you will learn

  • Design an Appropriate Data Access Technologies
  • Design an Appropriate Data Access Object Model
  • Design a Cursor Strategy for a Data Access Component
  • Design Caching Strategies
  • Design client libraries to write applications that administer the SQL Server service
  • Design queries that use multiple active Results sets (MARS)
  • Write and modify queries
  • Design queries for retrieving data from XML sources
  • Design a Cursor Strategy
  • Define code that validates input data and permissions
  • Design code that detects and react to errors
  • Design user-defined messages to communicate application events
  • Manage Concurrency by selecting the appropriate Transaction Isolation Level
  • Design the Locking Granularity Level
  • Design Transaction Scopes
  • Design codes that uses Transactions
  • Optimize and tune queries for performance
  • Optimize Indexing Strategies
  • Scale Database Application
  • Resolve Performance problems
  • Optimize Data storage