MyResearchInstitute.com

    My Research Institute
 
 

Exams.ws

 

 Universityofamericas.com- Convert your experience and certifications into University Degree for as low as $ 49.00. 

 

Microsoft exam 70-228, Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition.

 

 

 Exam topics include: installing and configuring SQL Server 2000; creating SQL Server 2000 databases; managing, monitoring, and troubleshooting SQL Server 2000 databases; extracting and transforming data with SQL Server 2000; managing and monitoring SQL Server 2000 security; and managing, monitoring and troubleshooting SQL Server 2000.

 

Exam #:   70-228

Status: Active

Time Limit: 90 min. 

Avg. Time: 48 min.

Passing Score: Pass/Fail

# of Questions: 50

Format: Form-based

Difficulty: 2

Certifications: MCP, MCDBA, MCSE

 

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

Citrix Braindumps, CIW Braindumps, Comptia Braindumps, Novell Braindumps

 

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.

  1.                         Perform a custom upgrade.

  2.                         Upgrade to SQL Server 2000 from SQL Server 6.5.

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

  1.                         Add filegroups.

  2.                         Configure filegroup usage.

  3.                         Expand and shrink a database.

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

  5.                         Size and place the transaction log.

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

Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases

Optimize database performance. Considerations include indexing, locking, and recompiling.

Optimize data storage.

  1.                         Optimize files and filegroups.

  2.                         Manage database fragmentation.

Modify the database schema.

Perform disaster recovery operations.

  1.                         Perform backups.

  2.                         Recover the system state and restore data.

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

  1.                         Manage OLE DB Providers.

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

  1.                         Add and remove users from roles.

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

  1.                         Monitor hardware resource usage by using System Monitor.

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

  1.                         Monitor SQL Server system activity by using traces.

  2.                         Monitor SQL Server system activity by using System Monitor.

 

EXAMS INFORMATION

 

Microsoft

                    70-028               70-029               70-056               70-080               70-081

                    70-086               70-088               70-098               70-210               70-214

                    70-215               70-216               70-217               70-218               70-219

                    70-220               70-224               70-227               70-229               70-270

 

Universityofamericas.com - Convert your experience and certifications into University Degree for as low as $  49.00. 

Brain-dumps.com This dumps site is first choice for dumpers and exam takers. There is wide range of vendors and certifications.

1