Exam Essentials

Before you take the exam, you should understand the following:

Know how to establish the business requirements for the quality of your data. Be familiar with the strategies that are used in the process of gathering information and capturing data requirements. You must understand the attributes of data quality and have knowledge of the tools that are available for you to manage and verify data.

Know how to create queries to inspect your data. Understand how to use queries to validate data. You must understand the difference between the various join types and how each can be used in analyzing your data. Know how to use set statements to analyze your data and when to use them to your advantage.

Know how to use checksum when verifying ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.