Exams > Search for an Exam

Preparation Guide for Exam 70-028

Administering Microsoft SQL Server 7.0

Updated: June 27, 2003
Related Links
•Register for this Exam
•Take a Practice Test
•Join an MCP Newsgroup
•Find a Course
•Buy a Microsoft Press Book

This exam is scheduled to be discontinued on June 30, 2004.

On This Page
Exam NewsExam News
Credit Toward CertificationCredit Toward Certification
Preparation Tools and ResourcesPreparation Tools and Resources
Skills Being MeasuredSkills Being Measured

Exam News

Exam 70-028 is scheduled to be discontinued and will not be available after June 30, 2004. For more information about discontinued exams, please see the Discontinuation of Exams page.

Exam 70-028 is available April 21, 1999.

Top of pageTop of page

Credit Toward Certification

When you pass the Designing and Implementing Data Warehouses with Microsoft SQL Server™ 7.0 exam, you achieve Microsoft Certified Professional status. You also earn credit toward the following certifications:

•

Core credit toward Microsoft Certified Database Administrator on Microsoft SQL Server 2000 certification

•

Elective credit toward Microsoft Certified Systems Engineer on Microsoft Windows 2000 certification

•

Elective credit toward Microsoft Certified Systems Engineer on Microsoft Windows NT 4.0 certification

•

Elective credit toward Microsoft Certified Systems Engineer + Internet on Microsoft Windows NT 4.0 certification

Top of pageTop of page

Preparation Tools and Resources

We make a wealth of preparation tools and resources available to you, including courses, books, practice tests, and Microsoft Web sites. When you are ready to prepare for this exam, here's where you should start.

Instructor-led Course for This Exam

•

Course 832: System Administration for Microsoft SQL Server 7.0

Microsoft Press Self-Paced Training

•

Microsoft SQL Server 7.0 System Administration Training Kit (ISBN: 1-57231-827-9)
This book is out of print. Check with your local retailer for availability.

Microsoft Certified Practice Tests

•

MeasureUp: Visit the MeasureUp Web site to take a practice test.

•

Self Test Software: Visit the Self Test Software Web site to take a practice test.

Microsoft Online Resources

•

TechNet: Designed for IT professionals, this site includes How-tos, best practices, downloads, technical chats, and much more.

•

MSDN: The Microsoft Developer Network (MSDN) is a reference for developers, featuring code samples, technical articles, newsgroups, chats, and more.

•

Training & Certification Newsgroups: A newsgroup exists for every Microsoft certification. By participating in the ongoing dialogue, you take advantage of a unique opportunity to exchange ideas with and ask questions of others, including more than 750 Microsoft Most Valuable Professionals (MVPs) worldwide.

Top of pageTop of page

Skills Being Measured

This certification exam measures your ability to administer a Microsoft SQL Server version 7.0 database. Before taking the exam, you should be proficient in the job skills listed in the matrix below.

Key to the matrix:

KEY:The course includes material to prepare you for this task. = The course includes material to prepare you for this task.    The course includes some material to prepare you for this task. You will need to supplement the course with additional work. = The course includes some material to prepare you for this task. You will need to supplement the course with additional work.
Skills measured by exam 70-028Course 832
Planning 

Develop a security strategy.

•

Assess whether to use Microsoft Windows NTŪ accounts or Microsoft SQL Server logins.

•

Assess whether to leverage the Windows NT group structure.

•

Plan the use and structure of SQL Server roles. Server roles include fixed server, fixed database, and user-defined database.

•

Assess whether to map Windows NT groups directly into a database or to map them to a role.

•

Assess which Windows NT accounts will be used to run SQL Server services.

•

Plan an n-tier application security strategy, and decide whether to use application roles or other mid-tier security mechanisms such as Microsoft Transaction Server.

•

Plan the security requirements for linked databases.

The course includes material to prepare you for this task.

Develop a SQL Server capacity plan.

•

Plan the physical placement of files, including data files and transaction log files.

•

Plan the use of filegroups.

•

Plan for growth over time.

•

Plan the physical hardware system.

•

Assess communication requirements.

The course includes material to prepare you for this task.

Develop a data availability solution.

•

Choose the appropriate backup and restore strategy. Strategies include full database backup; full database backup and transaction log backup; differential database backup with full database backup and transaction log backup; and database files backup and transaction log backup.

•

Assess whether to use a standby server.

•

Assess whether to use clustering.

The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

Develop a migration plan.

•

Plan an upgrade from a previous version of SQL Server.

•

Plan the migration of data from other data sources.


Develop a replication strategy.

•

Given a scenario, design the appropriate replication model. Replication models include single Publisher and multiple Subscribers; multiple Publishers and single Subscriber; multiple Publishers and multiple Subscribers; and remote Distributor.

•

Choose the replication type. Replication types include snapshot, transactional, and merge.

The course includes material to prepare you for this task.

Installation and Configuration 

Install SQL Server 7.0.

•

Choose the character set.

•

Choose the Unicode collation.

•

Choose the appropriate sort order.

•

Install Net-Libraries and protocols.

•

Install services.

•

Install and configure a SQL Server client.

•

Perform an unattended installation.

•

Upgrade from a SQL Server 6.x database.

The course includes material to prepare you for this task.

Configure SQL Server.

•

Configure SQL Mail.

•

Configure default American National Standards Institute (ANSI) settings.

The course includes material to prepare you for this task.

Implement full-text searching.


Configuring and Managing Security 

Assign SQL Server access through Windows NT accounts, SQL Server logins, and built-in administrator logins.

The course includes material to prepare you for this task.

Assign database access to Windows NT accounts, SQL Server logins, the guest user account, and the dbo user account.

The course includes material to prepare you for this task.

Create and assign SQL Server roles. Server roles include fixed server, fixed database, public, user-defined database, and application.

The course includes material to prepare you for this task.

Grant to database users and roles the appropriate permissions on database objects and statements.

The course includes material to prepare you for this task.

Audit server and database activity.

The course includes material to prepare you for this task.

Managing and Maintaining Data 

Create and manage databases.

•

Create data files, filegroups, and transaction log files.

•

Specify growth characteristics.

The course includes material to prepare you for this task.

Load data by using various methods. Methods include the INSERT statement, the SELECT INTO statement, the bcp utility, Data Transformation Services (DTS), and the BULK INSERT statement.


Back up system databases and user databases by performing a full database backup, a transaction log backup, a differential database backup, and a filegroup backup.

The course includes material to prepare you for this task.

Restore system databases and user databases from a full database backup, a transaction log backup, a differential database backup, and a filegroup backup.

The course includes material to prepare you for this task.

Manage replication.

•

Configure servers, including Distributor, Publisher, and Subscriber.

•

Create publications.

•

Set up and manage subscriptions.

The course includes material to prepare you for this task.

Automate administrative tasks.

•

Define jobs.

•

Define alerts.

•

Define operators.

•

Set up SQLAgentMail for job notification and alerts.

The course includes material to prepare you for this task.

Enable access to remote data.

•

Set up linked servers.

•

Set up security for linked databases.


Monitoring and Optimization 

Monitor SQL Server performance.

The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

Tune and optimize SQL Server.


Limit resources used by queries.


Troubleshooting 

Diagnose and resolve problems in upgrading from SQL Server 6.x.


Diagnose and resolve problems in backup and restore operations.

The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

Diagnose and resolve replication problems.

The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

Diagnose and resolve job or alert failures.

The course includes some material to prepare you for this task. You will need to supplement the course with additional work.

Diagnose and resolve distributed query problems.


Diagnose and resolve client connectivity problems.


Diagnose and resolve problems in accessing SQL Server, databases, and database objects.


Note: This preparation guide is subject to change at any time without prior notice and at Microsoft's sole discretion. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use the exam objectives listed in this preparation guide to prepare for the exam, regardless of its format. Learn more, and download samples, on the Testing Innovations page.


Top of pageTop of page