Microsoft Braindumps


Home Notes



Software Marketing


Microsoft Braindumps, exam 70-028, Administering Microsoft SQL Server 7.0.


 Exam topics include Planning, Installation & Configuration, Configuring & Managing Security, Managing & Maintaining Data, Monitoring & Optimization, and Troubleshooting.


Exam #:   70-028

Status: Active

Time Limit: 90 min. 

Avg. Time: 60 min.

Passing Score: 680

# of Questions: 52

Format: Form-based

Difficulty: 3

Certifications: MCP, MCSE, MCSE+I, MCDBA


Microsoft Braindumps, Oracle Braindumps, Sun Braindumps, Cisco Braindumps,

CitrixBraindumps, CIWBraindumps, ComptiaBraindumps, NovellBraindumps



Skills measured by exam 70-028 Course 832


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.


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.


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.


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.


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.


Configure SQL Server.

Configure SQL Mail.

Configure default American National Standards Institute (ANSI) settings.





Exam Questions