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.
PRO: Designing a Database Server Infrastructure by Using...


uCertify uses content from well known publishers, instructors, and subject matter experts. They have a minimum of 15 years of experience in their fields. uCertify brings these textbooks to life. It is full of interactive activities that keeps the learner engaged. uCertify brings all available learning resources for a topic in one place so that the learner can efficiently learn without going to multiple places. Challenge questions are also embedded in the chapters so learners can attempt those while they are learning about that particular topic. This helps them grasp the concepts better because they can go over it again right away which improves learning. Learners can do Flashcards, Exercises, Quizzes and Labs related to each chapter. At the end of every lesson, uCertify courses guide the learners on the path they should follow.

uCertify platform supports 50+ different types of interactive activities, connect the idea, or try it yourself lab activities embedded throughout its course. These interactive activities keeps learners engaged and makes learning fun.

Here's What You Get

Exercises Flashcards Quizzes

Each lesson comes with Exercises, Flashcards & Quizzes. There is no limit to the number of times learners can attempt these. Exercises come with detailed remediation, which ensures that learners are confident on the topic before proceeding. Flashcards help master the key concepts.

Exercise Questions

Test Prep & Practice Questions

uCertify provides full length practice tests. These tests closely follow the exam objectives and are designed to simulate real exam conditions. Each course has a number of test sets consisting of hundreds of items to ensure that learners are prepared for the certification exam.

Here's What You Get

Pre-assessments Questions
Full Length Tests
Post-Assessments Questions


Full Remediation

Each question comes with detailed remediation explaining not only why an answer option is correct but also why the incorrect answer options are incorrect.

Unlimited Practice

Each test can be taken unlimited number of times until the learner feels they are prepared. Learner can review the test and read detailed remediation. Detailed test history is also available.

Learn, Test and Review Mode

Each test set comes with learn, test and review modes. In learn mode, learners will attempt a question and will get immediate feedback and complete remediation as they move on to the next question. In test mode, learners can take a timed test simulating the actual exam conditions. In review mode, learners can read through one item at a time without attempting it.

Exam Information

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.

Career Prospects

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

  • Database Administrators
  • Database Developers
  • Application Developers
Exam FAQs
What is the exam registration fee?
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?

(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.

Table of Content

Here's What you will Learn

Lesson 1: Designing a Database Server Infrastructure

  • Design for capacity requirements.
  • Specify software versions and hardware configurations.
  • Design physical storage.
  • Design instances.
  • Design a database consolidation strategy.

Lesson 2: Design Security for a Database Server Solution

  • 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.

Lesson 3: Designing a Physical Database

  • 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.

Lesson 4: Design a Database Solution for High Availability

  • 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.

Lesson 5: Design a Data Recovery Solution for a Database

  • Specify data recovery technologies based on business requirements.
  • Design backup strategies.
  • Create a disaster recovery plan.

Lesson 6: Designing a Strategy for Data Archiving

  • 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.