70-228

Saturday, November 29, 2008, 21:24
Exam Details
76 views
6 comments

Preparation Guide for Exam 70-228
Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
Updated: September 2, 2008
Exam news
Exam 70-228 became available in January 2001.

• This exam is scheduled to retire in March 2009
• This exam is available at 40 percent off retail price until it retires

Audience profile
Candidates for this exam operate in medium-sized to very large computing environments that use Microsoft SQL Server 2000 Enterprise Edition. Candidates have at least one year of experience administering SQL Server. They also have at least one year of experience implementing relational databases in environments that contain:

• Heterogeneous databases.

• SQL Server security integrated with Windows Authentication.

• Client/server configurations of 50 to 5,000 or more users.

• Web configurations that use Microsoft Internet Information Services (IIS) or COM+.

• Databases as large as two terabytes.

• Multiple installations of SQL Server 2000.

Credit toward certification
When you pass Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition, you achieve Microsoft Certified Professional (MCP) status.

• Learn about 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 Administrator on Microsoft Windows 2000 certification

Database professionals who use Microsoft SQL Server 2005 should consider the Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) credentials. They provide IT professionals with a simpler and more targeted framework to display their technical and on-the-job skills.

• Learn about Microsoft Certified Technology Specialist certification
• Learn about Microsoft Certified IT Professional certification

Preparation tools and resources
To help you prepare for this exam, Microsoft Learning recommends that you have hands-on experience with the product and that you use the following training resources. These training resources do not necessarily cover all of the topics listed in the “Skills measured” section.

Classroom training Microsoft E-Learning Microsoft Press books Practice tests
(Prerequisite) Course 2071: Querying Microsoft SQL Server 2000 with Transact-SQL (two days)

Course 2072A: Administering a Microsoft SQL Server 2000 Database
There is no Microsoft E-Learning training currently available.
MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 System Administration, Exam 70-228, Second Edition (ISBN: 9780735619616)
MeasureUp
(Measureup.com)

Self Test Software
(Selftestsoftware.com)

Microsoft online resources
• Learning Plan: Get started with a step-by-step study guide that is based on recommended resources for this exam.

• Microsoft Learning Community: Join newsgroups and visit community forums to connect with peers for suggestions on training resources and advice on your certification path and studies.

• TechNet: Designed for IT professionals, this site includes how-to instructions, best practices, downloads, technical resources, newsgroups, and chats.

• MSDN: Designed for developers, the Microsoft Developer Network (MSDN) features code samples, technical articles, downloads, newsgroups, and chats.

Skills measured
This certification exam measures your ability to administer and troubleshoot information systems that incorporate Microsoft SQL Server 2000 Enterprise Edition. Before taking the exam, you should be proficient in the job skills listed in the following table.

Skills measured by Exam 70-228
Installing and Configuring SQL Server 2000
Install SQL Server 2000. Considerations include clustering, default collation, file locations, number of instances, and service accounts.

Upgrade to SQL Server 2000.

• Perform a custom upgrade.

• Upgrade to SQL Server 2000 from SQL Server 6.5.

• Upgrade to SQL Server 2000 from SQL Server 7.0.

Create a linked server.

Configure SQL Mail and SQLAgentMail.

Configure network libraries.

Troubleshoot failed installations.

Creating SQL Server 2000 Databases
Configure database options for performance. Considerations include capacity, network connectivity, physical drive configurations, and storage locations.

Attach and detach databases.

Create and alter databases.

• Add filegroups.

• Configure filegroup usage.

• Expand and shrink a database.

• Set database options by using the ALTER DATABASE or CREATE DATABASE statements.

• Size and place the transaction log.

Create and manage objects. Objects include constraints, indexes, stored procedures, triggers, and views.

Donwload Free Certbible, The Most Realistic Practice Questions and Answers,Help You Pass any Exams

Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases
Optimize database performance. Considerations include indexing, locking, and recompiling.

Optimize data storage.

• Optimize files and filegroups.

• Manage database fragmentation.

Modify the database schema.

Perform disaster recovery operations.

• Perform backups.

• Recover the system state and restore data.

• Configure, maintain, and troubleshoot log shipping.

Perform integrity checks. Methods include configuring the Database Maintenance Plan Wizard and using the Database Consistency Checker (DBCC).

Troubleshoot transactions and locking by using SQL Profiler, SQL Server Enterprise Manager, or Transact-SQL.

Extracting and Transforming Data with SQL Server 2000
Set up IIS virtual directories to support XML.

Import and export data. Methods include the Bulk Insert task, the bulk copy program, Data Transformation Services (DTS), and heterogeneous queries.

Develop and manage DTS packages.

Manage linked servers.

• Manage OLE DB Providers.

• Configure security mapping.

Convert data types.

Configure, maintain, and troubleshoot replication services.

Managing and Monitoring SQL Server 2000 Security
Configure mixed security modes or Windows Authentication. Considerations include client connectivity, client operating system, and security infrastructure.

Create and manage log ons.

Create and manage database users.

Create and manage security roles. Roles include application, database, and server.

• Add and remove users from roles.

• Create roles to manage database security.

Enforce and manage security by using stored procedures, triggers, views, and user-defined functions.

Set permissions in a database. Considerations include object permissions, object ownership, and statement permissions.

Manage security auditing. Methods include SQL Profiler and C2 auditing.

Managing, Monitoring, and Troubleshooting SQL Server 2000
Create, manage, and troubleshoot SQL Server Agent jobs.

Configure alerts and operators by using SQL Server Agent.

Optimize hardware resource usage. Resources include CPU, disk I/O, and memory.

• Monitor hardware resource usage by using System Monitor.

• Resolve system bottlenecks by using System Monitor.

Optimize and troubleshoot SQL Server system activity. Activities include cache hits, connections, locks, memory allocation, recompilation, and transactional throughput.

• Monitor SQL Server system activity by using traces.

• Monitor SQL Server system activity by using System Monitor.

The microsoft 70-228 certificates give you possibility to work in any country of the world because they are acknowledged in all countries equally. This microsoft 70-228 torrent certificate helps
not only to improve your knowledge and skills, but it also helps your career, gives a possibility for qualified usage of microsoft 70-228 exam products under different conditions. The
majority of companies in the sphere of information technologies require the presence of microsoft 70-228 exams for the work in the company, and that makes obtaining this microsoft 70-228
certificate necessary. Many IT specialists were not able to obtain the real microsoft 70-228 certificate from the first attempt, which was the result of poor preparation for the
examination, using preparatory microsoft 70-228 study guide of poor quality.

The leader among the providers of microsoft 70-228 preparatory materials is products such as microsoft 70-228 vce pdf Braindumps, microsoft 70-228 Tutorial, microsoft 70-228 Exam Questions with Answers, microsoft 70-228
Trainings, microsoft 70-228 Test Online Simulations Course and free PDF. It obtained its leadership and trust of the users from the very beginning of its work on the microsoft 70-228 training
materials market. All the microsoft 70-228 value pack aids have been created by people who are personally familiar with actualtests microsoft 70-228 Preparation Labs and who know all the
difficulties and popular mistakes made by those who take a microsoft 70-228 . The entire material is logically composed in such a way that everything becomes easy to understand for
anyone. full download Many microsoft 70-228 guides include audio and video material. It is really easy to acquire microsoft 70-228 exams because of great variety of methods of payment.

pass4sure testking microsoft 70-228 transcender rapidshare 4shared links