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 :)
CramSession Memeber Benefit: Subscribe to Windows IT Pro for FREE!
Windows IT Pro is the only independent resource for managing, securing, and troubleshooting the Windows enterprise. Included in your subscription is: The inside scoop on
Microsoft won't tell you about Windows Server; Access to veteran experts like Mike Otey, Mark Minasi, and Paul Thurrott; Thousands of tips and solutions to help you get more done in less time; Tips
from the trenches and other nuggets of wisdom from readers like you; Comprehensive coverage of Active Directory, security, virtualization and disaster recovery, and more; Comparative, thorough, and
impartial product reviews; Admission into the single largest IT community in the world!
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.
CCNA & CCNP Lab Suggestions
Many people ask me what would make a good CCNA lab? Well, that can be a tricky question based upon your budget and future Cisco aspirations. So let’s start off with a few basic concepts I hope we can
all agree on. Real Routers. Read more…
Email this Page
Not as easy as you think