Upgrade MCDBA to MCITP Exam 70-447: Upgrade MCDBA skills to MCITP Database Administrator by Using Microsoft SQL Server 2005
E X A M D I F F I C U L T Y
SYNOPSIS • MCITP Database Administratorvs
Candidates for this exam are Professional Database Administrators responsible for optimizing and maintaining database solutions. They have 3 or more years dedicated to database work, which would include two or more of the following phases in the product lifecycle: design, development, deployment, optimization, maintenance, or support. The typical work environment is an enterprise or a medium sized organization. Candidates should be experienced in using Microsoft SQL Server 2005.
Candidates for this exam should have expert knowledge of the following areas:
Defining high availability solutions
Automating administrative tasks
Defining security solutions
Monitoring and troubleshooting the database server
Designing and executing deployments
Defining the infrastructure (storage, hardware, and number of servers or instances, etc.)
This certification exam measures your ability to optimize and maintain a database administration solution using SQL Server 2005.
The official domains of this exam are:
Designing a Database Server Infrastructure
Designing Security for a Database Server Solution
Designing a Physical Database
Designing a Database Solution for High Availability
Designing a Data Recovery Solution for a Database
Designing a Strategy for Data Archiving
Optimizing the Performance of Database Servers and Databases
Optimizing and Implementing a Data Recovery Plan for a Database
Designing a Strategy to Monitor and Maintain a Database Solution
Designing a Database Data Management Strategy
Designing a Strategy to Manage and Maintain Database Security
This exam has a multiple choice section and a case study section. It is quite long. I passed this exam 1 month after taking 70-431. I was thinking that I failed before the finish, but I squeeked one out. I read both 70-443 and 70-444 MS press books. They are very dry though.
Prepare to read and scroll ...
cert_spawn on Monday, December 04, 2006
... a lot !
I'm based in Ireland, took the test on Friday. Passed with 900/1000 using many years of SQL experience and almost 2 years of using 2005 in a test/production environment.
My test had 62 questions in all.
The case study questions are lenghty, with loads of misleading and useless information. To be honest on some questions I thought the right answer wasnt even shown.
The straight forward questions are better, tho short and leaving very little background to make the right choice in a few instances.
Mind you that once you exit a case study you cannot review it at a later stage, so take all the time you need on each of them.
Summing it up, I'm glad I passed surely because this exam is quite difficult. If you took 70-431 and stormed through it (I got 1000 on that one), prepare for a surprise bacause this one ain't straightforward.
Good luck all :)
Earn an affordable, online bachelor's degree in Information Technology—Security Emphasis
plus nine IT certifications including Sun Certified Programmer for the Java Platform, MySQL Core, and Security+. Your prior college and IT certifications may waive some degree requirements FREE subscription to Network World.
Your complimentary subscription will include 50 weekly issues jam packed with news analysis, expert industry opinion and management/career advice, all of which is packaged with your business needs in mind. We want to help you connect the technology dots and help you advance your company's business goals
Email this Page
Not as easy as you think