Microsoft MCDBA 70-229

Free Study Guides

Practice Exams

CISSP

CCNP

MORE...

KEYWORD: MCSE

Email this Page

SQL 2000 Design
Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

E X A M D I F F I C U L T Y
• What to Know • Study Tips • MCAD .NET Articles • MCDBA Articles • MCSD .NET Articles • MCSE 2000 Articles • MCSE 2003 Articles • Discussion Board

SYNOPSIS • MCAD .NET ^vs • MCDBA ^vs • MCSD .NET ^vs • MCSE 2000 ^vs • MCSE 2003 ^vs
Microsoft’s exam 70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition is a core requirement for the MCDBA (Microsoft Certified Database Administrator) on SQL Server 2000 certification. It is designed for candidates who work in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition.

There is no specific prerequisite for this exam but Microsoft does make the following recommendations: Candidates should have at least one year of experience implementing relational databases in environments with these characteristics: heterogeneous databases; SQL Server security integrated with Windows Authentication; client/server configurations of 50 to 5,000 or more users; web configurations that use IIS or COM+; databases as large as 2 TB; and multiple installations of SQL Server 2000.

Exam 70-229 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; MCSD (Microsoft Certified Solution Developer) for Microsoft .NET; MCSD (Microsoft Certified Solution Developer); and MCAD (Microsoft Certified Application Developer) for Microsoft .NET.

The domains covered by this exam include:

Developing a Logical Data Model
Implementing the Physical Database
Retrieving and Modifying Data
Programming Business Logic
Tuning and Optimizing Data Access
Designing a Database Security Plan

Helpful: Compare this exam with others.

Prometric Microsoft Exam Voucher This Microsoft Exam Voucher retails for more at the exam centers, but you can save today when you buy the discount exam voucher here. This is an official MCSE exam voucher and can be used at thousands...	$124.00 ~~$125.00~~	PDF/ Voucher Code

SQL Server 2000 Database Design (70-229) LearnSmart Video Training Gain in-depth SQL Server 2000 Implementing Database Design (70-229) knowledge from industry-leading instructor Wayne Snyder. Wayne provides expert insight and sincere excitement for technology in this...	$635.00	CD

Subscribe to our Free Must Know News Newsletter
Name: Email:

User Reviews

10 Total Comments: 10 | 25 | 50

Not as easy as you think	achristenson on Thursday, March 22, 2007

I had to take this exam 3 times. They trick you on the questions that have code in the answers. The answers have little differences like commas, ands, as well as other subtle changes. Take your time to read every answer before you choose.

Be Prepared	ddtater on Saturday, February 10, 2007

This is no cake walk despite what some may say. If you have a solid foundation and experience in logical db design and usage you will still find this exam quite challenging.

If you study you will pass	als7sda on Thursday, January 26, 2006

Passable if you study

Train Hard - Fight easy	roymatthews on Monday, October 31, 2005

Spent quite a few months preparing for this one from the Sybex book. Tossed the Microsoft book away because it was so horrible to read. I found the exam easier than the three I took for my MCAD .NET but spent more time preparing. It certainly was not as hard as I expected.

Forget the MS training course	j_a_saunders on Thursday, March 03, 2005

I did the 5 day offical Microsoft training course and it didn't cover half of what was on the exam. It's the last course I'll be going on for a while as I go back to self study. The books appear to cover all the examined topics, but the courses don't match up when it comes to Microsoft. This was the one I needed for MCDBA, so MCAD.NET or MCSE Messaging 2k3 next for me. Not sure which yet.

HARD!	leeab070 on Friday, January 28, 2005

A lot harder than all the practise tests I tried. Had some 'beta' questions which were not part of the usual curriculum and were only there because Microsoft are deciding whether they should expand the 70-229 curriculum.

study guides vs exam	lornaw on Sunday, January 02, 2005

Interesting to see that most of the topics covered by study guides did not crop up at all, and my exam seemed to focus on a few limited topics. I passed first time though with 89%

Study and pass...	cmeneghel on Tuesday, December 28, 2004

Just study, take Transcender/PrepLogic and pass. I passed on this exam yesterday Dec, 27 and my score was 870.

Not a bad exam.	commoner on Thursday, December 02, 2004

This exam is not difficult. Take your time and read the questions and answers carefully.

Study hard.	poor_tatey on Monday, November 08, 2004

I kept taking practice tests and failing, so I knew I wasn't ready. Don't underprepare.