70-443 : PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005

Retired. This product is no longer available.

The Microsoft Certified IT Professional: Database Administrator certification is an industry recognized vendor neutral credential. The certification is proof of a person's competence across a spectrum of skills including optimizing and maintaining database solutions. They have experience in database work, which may include two or more of the following phases in the product lifecycle: design, development, deployment, optimization, maintenance, or support.
19
70-443
PRO: Designing a Database Server Infrastructure by Using...

Here's what you will get

The certification is targeted at Database Administrators involved with installing or configuring Microsoft SQL Server 2005 and managing or maintaining databases or multidimensional databases. The exam covers how to define high-availability solutions, automate administrative tasks, define security solutions, monitor and troubleshoot the database server, design and execute deployments, define the infrastructure.

Lessons
Lessons
6+
Exercises
102+
Quizzes
109+
TestPrep
Pre-assessment Questions
15+
Full Length Tests
3+
Post-Assessment Questions
27+
Exam FAQs
What is the exam registration fee? 150
Where do I take the exam? The PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 is administered by Prometric at testing centers worldwide. Click here to find a testing center near you.
What are the pre-requisites of the exam? While there are no official prerequisites to take the MCITP certification, both Microsoft and uCertify strongly recommend that the candidates for this exam should have expertise in using Microsoft SQL Server 2005 and should be an expert in the area defined by Microsoft. Click here for more details.
How many questions are asked in the exam? The exam contains 50 questions.
What is the duration of the exam? 120 minutes
What is the passing score? 70%

(on a scale of 0-1000)

What is the exam's retake policy?

In the event that you fail your first attempt at passing the MCITP certification, Microsoft's retake policy is:

  • If a candidate does not achieve a passing score on an exam the first time, he must wait at least a 24-hour period before retaking the exam.
  • If a candidate does not achieve a passing score the second time, the candidate must wait at least a 14-day period before retaking the exam a third time.
  • A 14-day waiting period will also be imposed for the fourth and fifth subsequent exam retakes.
  • A candidate may not take a given exam any more than five times per year (12 months). This 12-month period would start the day of the fifth unsuccessful exam retake.
  • The candidate would then be eligible to retake the exam 12 months from that date. In order to take a given exam more than five times per year, a candidate must submit a request and obtain prior permission from Microsoft.
What is the validity of the certification? MCITP has no expiration. The certification holder is certified for life unless the vendor changes their policy. Click here for more information.
Where can I find more information about this exam? To know more about the 70-443, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?

A Microsoft MCITP: Databse Administrator certified professional has several career opportunities open up to them, including:

  • Database Administrators
  • Database Developers
  • Application Developers

Here's what you will learn

  • Design for capacity requirements.
  • Specify software versions and hardware configurations.
  • Design physical storage.
  • Design instances.
  • Design a database consolidation strategy.
  • Analyze business requirements.
  • Integrate database security with enterprise-level authentication systems.
  • Develop Microsoft Windows server-level security policies.
  • Modify the security design based on the impact of network security policies.
  • Analyze the risk of attacks to the server environment and specify mitigations.
  • Design SQL Server service-level security.
  • Design database-level security.
  • Design object-level security.
  • Modify an existing database design based on performance and business requirements.
  • Design tables.
  • Design file groups.
  • Design index usage.
  • Design views.
  • Create database conventions and standards.
  • Create database change control procedures.
  • Select high-availability technologies based on business requirements.
  • Develop a strategy for migration to a highly available environment.
  • Design a highly available database storage solution.
  • Design a database-clustering solution.
  • Design database mirroring.
  • Design a high-availability solution that is based on replication.
  • Design log shipping.
  • Specify data recovery technologies based on business requirements.
  • Design backup strategies.
  • Create a disaster recovery plan.
  • Select archiving techniques based on business requirements.
  • Design the format of archival data.
  • Specify what data to archive.
  • Plan for data archival and access.
  • Design the topology of replication for archiving data.
  • Design the type of replication for archiving data.