70-029

(70-029) SQL 7.0 Design

SYNOPSIS • MCDBA ^vs • MCSE 2000 ^vs

Microsoft’s exam 70-029, "Designing and Implementing Databases with Microsoft SQL Server 7.0" is a core requirement for the MCDBA (Microsoft Certified Database Administrator) on SQL Server 2000 certification. It is designed for candidates who "design and implement a database solution by using Microsoft SQL Server version 7.0" There is no specific prerequisite for this exam.

Exam 70-029 is also an elective for these other certifications: MCSE (Microsoft Certified Systems Engineer) on Windows 2000; MCSE (Microsoft Certified Systems Engineer) on Windows NT 4.0; MCSE (Microsoft Certified Systems Engineer) + Internet on Windows NT 4.0; and MCSD (Microsoft Certified Solution Developer).

This exam is moderately difficult and costs $125 USD. It may be taken from Pearson Vue or Thomson Prometric.

At one time this exam provided no pass score other than Pass/Fail, but this is subject to change. “Beginning with the release of the Microsoft Windows Server™ 2003•related exams, Microsoft will provide numerical scores on exams. By the end of September 2003, most exams will have the new score report format, which includes this numerical score... The new scale requires a minimum passing score of 700 on all exams. The maximum score on the exams will vary depending on the complexity of the skills being measured.� - Microsoft Exam and Testing Procedures FAQ

Note that Microsoft does not document the format of a particular exam: “Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented.� In the past, though, this exam was form-based multiple choice with around 49 questions, some based on scenarios.

This exam is scheduled for retirement on June 30, 2004.

The topics covered by this exam include:

• Developing a Logical Data Model
• Deriving the Physical Design
• Creating Data Services
• Creating a Physical Database
• Maintaining a Database

For more information:
http://www.microsoft.com/traincert/exams/70-029.asp