Microsoft MCDBA 70-228

Free Study Guides

Practice Exams

CISSP

CCNP

MORE...

KEYWORD: MCSE

Email this Page

SQL 2000 Admin
Exam 70-228: Installing, Configuring, and Administering 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 • MCDBA Articles • MCSA 2003 Articles • MCSE 2000 Articles • MCSE 2003 Articles • Discussion Board

SYNOPSIS • MCDBA ^vs • MCSA 2003 ^vs • MCSE 2000 ^vs • MCSE 2003 ^vs
Microsoft’s exam 70-228, Installing, Configuring, and Administering 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 operate in medium to very large computing environments that use Microsoft SQL Server 2000 Enterprise Edition. There is no specific prerequisite for this exam but Microsoft recommends that candidates have at least one year of experience administering SQL Server.

Exam 70-228 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; and MCSA (Microsoft Certified Systems Administrator) on Windows 2000.

The domains covered by this exam include:

Installing and Configuring SQL Server 2000
Creating SQL Server 2000 Databases
Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases
Extracting and Transforming Data with SQL Server 2000
Managing and Monitoring SQL Server 2000 Security
Managing, Monitoring, and Troubleshooting SQL Server 2000

Helpful: Compare this exam with others.

SQL Server 2000 Administration (70-228) Quiz Me Series This title is available to you as a digital download or 2-CD set. This audio training product includes hours of questions and answers in a verbal quizzing format. Topics covered include:...	$47.00	CD

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~~	Software Download / Voucher Code

SQL Server 2000 Administration (70-228) Practice Exam This practice exam covers all the exam objectives for SQL Server 2000 70-228 and includes 135 challenging questions inside 3 test modules built to simulate the actual exam. Unlimited, FREE...	$109.00	Software Download

SQL Server 2000 Administration (70-228) LearnSmart Video Training Gain in-depth SQL Server 2000 Administration (70-228) knowledge from industry-leading instructor Wayne Snyder. Wayne provides expert insight and sincere excitement for technology in this comprehensive...	$555.00	CD

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

User Reviews

10 Total Comments: 10 | 25 | 50

not too hard, nor too easy	warbisizer on Wednesday, January 03, 2007

This test was a little bit harder than I had expected, but I passed with 757. Many questions on managing SQL Server itself (DBCC, backups, SQL Server settings, protocols, etc.), lots of SQL, lots of time spent analyzing code, and many questions on security and logins. There were several questions that required knowlege of various topics. i.e.- a question about database modification that also requires knowlege about certain security terms. (don't accuse me of piracy, I made that example up!) Tricky! Every test is quite different, so this may not be the case for YOU if you're preparing to take it. I purchased the SelfTest practice exams for SQL 2000 Admin, SQL 2000 Design, and Win 2000 Server. I HIGHLY recommend them as they are closer to the real thing than any other practice tests that I've seen out there, and between the included flash cards and answer explanations, cover almost everything that is necessary, without a bunch of other junk that is not on the tests.

Somewhat difficult	joe2397 on Saturday, September 17, 2005

I passed with an 811, but about 5 or 6 questions were pretty ticky. For the rest of the exam most of the questions were common sense and read the question carefully and take your time. It is not as hard as you think it is.

Disaster time.	grahamcp on Tuesday, December 28, 2004

The test was hard even with MS Books lots of practice tests. The first terminal I sat at locked up. Halfway through the test the remaining terminal (there were only two)did the same. I convinced the proctors to fix the !@#$@ machine in order to continue but by the time they did, a whole hour was gone. Passed with 730.

Easier than SQL 2000 Dev	AlistairL on Tuesday, December 07, 2004

The usual things you'd expect for administration of SQL Server. Lots to read like the developer exam, but overall it was less demanding.

Do both training courses!	j_a_saunders on Thursday, November 11, 2004

I did the training course 2072A Administering A MS SQL Server 2000 last week and about half the quest I got out of the 45 weren't covered on the training course. Do the course Course 2073 Programming a Microsoft SQL Server 2000 Database, which is for 70-229 before you do either exam as then together you've covered all the exam topics and can pass both exams fairly easily. I still passed with a score of 752, but could have done better.

Be sure, very sure	cbates413 on Wednesday, November 03, 2004

Most questions have a selection of answers that all seem correct, but in reality, the right answer is the one that best solves the question. There a few trick questions like how to allow someone access to SQL Server using the Guest account over the Internet; Pulling data in from multiple locations with least effort; Setting idle time with the @@IDLE (which can't be done as @@IDLE is read only). My score was 679 on first try and have studied for about 3 weeks (missed one too many questions). I'm a web developer with more experience over in 70-229 land.

Question difficulty varies	wiljane3 on Wednesday, June 16, 2004

I found the test to contain a wide variety as far as question difficulty. About 1/3 of them were very easy, about 10 (of the 45) questions were quite hard and had me second guessing myself a little, and the rest fell somewhere in between. I passed on my second try (missing the first time by one question) with moderate study and 2+ years experience working with SQL Server 2000.

INDEXES!	fintorg on Saturday, June 05, 2004

Make sure you know diff between clustered and nonclustered indexes, and how to optimize db design based upon the query being used.

tough test...	Crosan on Wednesday, May 19, 2004

Passed with experience, microsoft press books and Transcender

Hope these help	DavieC on Tuesday, May 04, 2004

Sat the exam twice. Failed first time due to insufficient study. Passed second time, make sure you read and understand the questions. Understand how security works, how to optimise performance and recovery techniques.