Microsoft 70-228 Braindumps
| Exam details |
|---|
| 70-228 : Installing, Configuring and Administering Microsoft SQL Server 2000, Enterprise Edition |
| Certification provider: Microsoft |
| 70-228 Exam Topics |
| 70-228 Exam Info |
Prerequisites: They must have a minimum of one year’s experience implementing and administering SQL Server 2000 Enterprise Edition in support of enterprise environments using client/server configurations of up to 5,000 or more users and databases as large as two terabytes
Exam Format:
Combination of Multiple Choice, Hot Area, Active Screen, Drag and Drop, Build list - sort and order, and Build a Tree question scenarios
Exam Layout and Design:
The format is as follows: Multiple Choice, Hot Area, Active Screen, Drag and Drop, Build list - sort and order, and Build a Tree question scenarios.
Number of Questions:
There are more or less 50 questions.
Time:
90 Minutes
Price:
$125 (USD)
Passing Score:
700
Difficulty Rating:
3/5
Title
Date
| Displaying Rows 1 - 30 of 578 | Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20  |
 Add Microsoft 70-228 Dump |
70-228 Exam Topics
- 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.
- 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 logons.
- 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.
70-228 Exam Info
Intended Audience: The exam of 70-228: Microsoft SQL Server 2000 System Administration is design for people who have at lease 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 2 terabytes.
- Multiple installations of SQL Server 2000.
The exam 70-288 has a difficulty rating of 3/5. The exam measures skills to administer and troubleshoot information systems that incorporate Microsoft SQL Server 2000 Enterprise Edition.
The exam consists of approximately 50 questions. The format is as follows: Multiple Choice, Hot Area, Active Screen, Drag and Drop, Build list - sort and order, and Build a Tree question scenarios. All candidates have 90 Minutes to complete the exam. The required score to pass exam 70-228 is 700.
Pass exam 70-228 Microsoft SQL Server 2000 System Administration and you achieve Microsoft Certified Professional (MCP). You also earn:
- 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
What you need to know
You must know how to install and configure the SQL Server 2000. You must know how clustering works. That means you must know the difference between clustered and non-clustered indexes. You must also have knowledge of the default collation. You must also know where the files are located. You must also know the type of instances and the number of instances. You must also know the different service accounts.
You must also be able to upgrade you system to SQL SERVER 2000. This means you must be able to perform a custom upgrade. You must be able to upgrade to a SQL Server 2000 from SQL Server 6.5, and must be able to upgrade from SQL Server 2000 from SQL Server 7.0.
You must also know how to set up a linked server. You must also be able to configure SQL Mail and SQLAgentMail. You must be able to configure and set up network libraries. Yu must know how to troubleshoot and fix failed installations.
You must be able to create and set up SQL Server 2000 Databases. This means you must be able to configure database options for performance. This means you must be able to create performance from you capacity. You must also be able to get performance from your network connectivity. You must know how to get the best performance from your physical drive configurations. You must also be able to get the best out of your storage locations.
You must be able to attach and detach the databases. You must be able to create and alter databases. This means you must know how to add file-groups. You must also be able to configure and set up file-group usage. You must be able to expand and shrink a database. You must be able to set database options by using the ALTER DATABASE or CREATE DATABASE statements. You must also be able to size and place the transaction log.
You must also be able to create and administrate objects. The objects include constraints, indexes. You must know stored procedures, triggers and views.
You must also know how to manage, monitor and troubleshoot the SQL Server 2000 database. This means you must be able to optimize the database performance. The considerations include indexing, locking and recompiling.
You must be able to optimize the data storage. This means you must be able to optimize the file and file-groups. You must also be able to administrate database fragmentation. You as an administrator must be able to modify or change the database schema.
You must be able to perform disaster recovery for the operations. This means you must be able to perform backups. You must be able to recover the system state and then also restore the data. You must be able to configure, maintain and troubleshoot the log shipping.
You must be able to do integrity checks. The method includes the configuration of the Database Maintenance Plan Wizard and using the Database Consistency Checker (DBCC). You must also be able to troubleshoot transactions and locking by using SQL Profiler, SQL Server Enterprise Manager, or Transact-SQL.
You must be able to extract and transform the data with the SQL Server 2000. This means you must be able to set up IIS virtual directories to support XML. You must also be able to import and export data. The methods you should use include the Bulk Insert task, the bulk copy program, Data Transformation Services (DTS), and heterogeneous queries.
You must be able to develop and manage the DTS packages. You must also know how to link servers. This means you must be able to manage the OLE DB Providers and you must be able to manage the configuration security mappings.
You must also know how to convert data types. You must also know how to Configure, maintain, and troubleshoot replication services.
You should also know how to manage and monitor SQL Server 2000 Security. This means you must be able to configure mixed security modes or Windows Authentication. The considerations include client connectivity, client operating system, and security infrastructure.
You must be able to create and to manage logons. You must also know how to create and manage the database users. You must also be able to set up and manage security roles. The roles include application, database, and server. This means you must be able to add and remove users from roles. You must also be able to create roles to manage database security.
You must be able to enforce and manage security by using stored procedures, triggers, views, and user-defined functions. You must also be able to set permissions in a database. The considerations include the object permissions, object ownership, and statement permissions. You must also be able to manage the security auditing. The methods include the SQL Profiler and C2 auditing.
You must be able to manage, monitor and troubleshoot the SQL Server 2000. It means that you must be able to create, manage and troubleshoot the SQL Server Agent jobs. You must also be able to configure and set up alerts and operators by using SQL Server Agent.
You must also be able to optimize hardware resource usage. The resources include the CPU, disk I/O and memory. This means you must be able to monitor hardware resource usage by using System Monitor. You must also be able to resolve bottlenecks by using the System Monitor.
You must be able to optimize and troubleshoot SQL Server system activity. The activities include cache hits, connections, locks, memory allocation, recompilation, and transactional throughput. This means you must be able to monitor the SQL Server system activity by using traces. And you must be able to monitor SQL Server system activity by using System Monitor.
| Add Microsoft 70-228 Dump |
| CertYourself - Free Practice Exams, Free Study Guides For MCSE, CCNA, A+, MCSD, N+ and much much more |
| Testking - The acknowledged leader in Certification Preparation |
| Real-Exams - We have the Questions you will see in your Exams |
| ExactQuestions - Register for free and Take FREE IT Courses! Click Here! |
| Exact-Exams - Quality Exam Preparation - Available NOW! |
