pass4sure Mcse 70-228 v2.83

MCSE Installing, Configuring and Administering Microsoft SQL Server 2000, Enterprise Edition : 70-228 Exam

Exam Number/Code: 70-228
Exam Name: MCSE Installing, Configuring and Administering Microsoft SQL Server 2000, Enterprise Edition
VUE Code: 70-228
Questions Type: Multiple choice,
Real Exam Question Numbers: 45 Question
Exam Language(s): English

“MCSE Installing, Configuring and Administering Microsoft SQL Server 2000, Enterprise Edition”, also known as 70-228 exam, is a Microsoft certification.
Preparing for the 70-228 exam? Searching 70-228 Test Questions, 70-228 Practice Exam, 70-228 Dumps?

With the complete collection of questions and answers, Pass4sure has assembled to take you through 135 questions to your 70-228 Exam preparation. In the 70-228 exam resources, you will cover every field and category in MCSE helping to ready you for your successful Microsoft Certification
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.

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.

Free PassGuide Practice Engine Demo Download Pass4sure offers free demos for each certification exam, including all IT vendors. You can check out the testing engine software, or pdf file question quality and usability of our practice exams before you decide to buy it. We are the only one site that offers demos for almost all IT certification exams.If you want to try p4s exam practice engine demo. http://demo.passguide.com/download

QUESTION 1
You work as a system administrator at Certkiller .com. All servers on the
Certkiller .com network run Windows 2000 Server. All client computers run either
Windows 98 or Novel NetWare. Your duties include administrating a member server named Certkiller -SR07.
You must install SQL Server 2000 on Certkiller -SR07 and create a database named CK_Data. You need to ensure that all Windows 98 and Novell NetWare
client computers can connect to the CK_Data database using the Named Pipes and IPX/SPX Net-Libraries respectively. You need to configure the client computers to connect to the CK_Data database using the minimum number of configuration changes on the client computers.
What should you do? (Each correct answer presents part of the solution. Choose
TWO.)

A. Configure the new instance to use Mixed Mode Authentication. B. Configure the new instance to use Windows Authentication.
C. Configure the new instance to use SQL Server Authentication.
D. Configure Certkiller -SR07 to use the Named Pipes and IPX/SPX Net-Libraries.
E. Configure Certkiller -SR07 to use the Multiprotocol Net-Library.
F. Configure Certkiller -SR07 to use the Shared Memory Net-Library. Answer: A, D
Explanation: The client computers in this scenario will be running Windows 98 and Novel NetWare. Novell NetWare clients are not supported by Windows Authentication; however SQL Server Authentication should only be used for backward compatibility. Hence you should use Mixed Mode Authentication.
By using specific communication protocols, and not the Multiprotocol Net-Library, performance would be better. Every extraneous protocol adds overhead.
Incorrect Answers:
B: As client computers will be running Windows 98 and Novel NetWare, you cannot use Windows Authentication as Novel NetWare systems are not supported by Windows Authentication.
C: SQL Server Authentication should only be used for backward compatibility. Hence you should use Mixed Mode Authentication.
E: The Multiprotocol Net-Library is used to support the different protocol that the clients use. This provides easy of administration. However, since unused protocols are installed,
it also introduces overhead. This is not the best solution.
F: Shared Memory is only supported for local database connection on the database server. It does not support database connections over the network.
Reference:
Microsoft SQL Server 2000 Books Online (2004), Index: Net-Library, setting up
Microsoft SQL Server 2000 Books Online (2004), Index: authentication, overview

QUESTION 2
You work as the database administrator at Certkiller .com. The Certkiller .com
network consists of a single Windows 2000 domain named Certkiller .com. All servers on the Certkiller .com network run Windows 2000 Advanced Server. The
Certkiller .com network contains a SQL Server 2000 database server named Certkiller -DB01. Certkiller -DB01 is a production server and hosts a database named CK_Sales which stores sales transactions for the company.
Certkiller .com has database application developer named Rory Allen who uses a Windows 2000 Professional client computer named Certkiller -WS228. Rory Allen needs to test a database application on Certkiller -DB01. You install a separate a
SQL Server 2000 instance named RA_Test on Certkiller -DB01. You need to ensure that Rory Allen can connect to the RA_Test instance.
What should you do?

A. Configure the RA_Test instance to use the Named Pipes Net-Library.
B. Configure the RA_Test instance to use the Multiprotocol Net-Library.
C. Configure the RA_Test instance to use the NWLink IPX/SPX Net-Library. D. Configure the RA_Test instance to use the Shared Memory Net-Library.

Answer: A

Explanation: Windows 2000 Professional can use the TCP/IP Sockets and Named
Pipes Net-Libraries by default. Incorrect Answers:
B: The Multiprotocol Net-Library can only be used to connect to a default instance of
SQL Server 2000 as it does not support named instances of SQL Server 2000.
C: The NWLink IPX/SPX Net-Library is used to support Novell NetWare clients.
D: Shared Memory is only supported for local database connection on the database server. It does not support database connections over the network.
Reference:
Microsoft SQL Server 2000 Books Online (2004), Index: Net-Library, overview
Microsoft SQL Server 2000 Books Online (2004), Index: Net-Library, setting up

QUESTION 3
You work as the database administrator at Certkiller .com. The Certkiller .com network consists of a single Windows 2000 domain named Certkiller .com. The Certkiller .com network contains a SQL Server 7.0 database server named Certkiller -DB01 that runs on Windows NT Server 4.0. Certkiller -DB01 is a production server and hosts several databases for the company.
You install SQL Server 2000 as the default instance on a new database server named Certkiller -DB02. Certkiller -DB02 runs Windows 2000 Server.
Certkiller .com users in the Accounts department must have direct access to the databases on both Certkiller -DB01 and Certkiller -DB02. The users in the Accounts department use client computers that run Windows 2000 Professional.
You need to encrypt the network communication between the Accounts department users’ client computers and the database servers.

What should you do?

A. Configure the client computers to use the Named Pipes Net-Library. B. Configure the client computers to use the Multiprotocol Net-Library.
C. Configure the client computers to use the TCP/IP Sockets Net-Library. D. Configure the client computers to use the Shared Memory Net-Library.
Answer: B Explanation:
Windows 2000 Professional can use the TCP/IP Sockets, Multiprotocol and Named
Pipes Net-Libraries by default. However, only the Multiprotocol Net-Library supports remote procedure call (RPC) encryption. RPC encryption is required because SQL Server 7.0 only supports RPC encryption.
Incorrect Answers:
A, C: Although the Windows 2000 Professional client computers can use the TCP/IP Sockets and Named Pipes Net-Libraries by default; and the TCP/IP Sockets and Named Pipes Net-Libraries support Secure Socket Layer (SSL), SQL Server 7.0 only supports remote procedure call (RPC) encryption which is only supported by the Multiprotocol
Net-Library.
D: Shared Memory is only supported for local database connection on the database server. It does not support database connections over the network.
Reference:
Microsoft SQL Server 2000 Books Online (2004), Index: Net-Library, overview Microsoft SQL Server 2000 Books Online (2004), Index: Net-Library, encryption Microsoft SQL Server 2000 Books Online (2004), Index: Net-Library, Multiprotocol

QUESTION 4
You work as the database administrator at Certkiller .com. The Certkiller .com
network consists of a single Windows 2000 domain named Certkiller .com. All servers on the Certkiller .com network run on Windows 2000 Server while the client
computers run Windows 2000 Professional, Windows 98, and Novell NetWare. All computers are members of the Certkiller .com domain. The Certkiller .com network contains a SQL Server 2000 database server named Certkiller -DB01 that hosts a default instance of SQL Server 2000.
Certkiller .com wants to implement another SQL Server 2000 instance for a database named Sales_DB. Sales_DB will store sales data for the company. All Certkiller .com users will require access to the Sales_DB database. You have been instructed to
create the SQL Server 2000 instance for the Sales_DB database. You need to ensure that all users will be able to connect to the Sales_DB database. You cannot make configuration changes to the client computers. Your solution must optimize network traffic.
What should you do?

A. Install the instance as a named instance and configure it to support Mixed Mode
Authentication. Then enable the NWLink IPX/SPX Net-Library for the instance.

pass4sure 70-228

Questions and Answers : 135 questions Expected Date: October 22nd , 2008 Price: $129.99 $89.99 Pre-Buy price: $62.99 Save $27

Free download:pass4sure Mcse 70-228 v2.83
Free download:testking Mcse 70-228 v2.83

PassGuide provides high-quality test materials, for example, Cisco CCNA CCNP CCIE, Comptia A + NETWORK + Security +, Juniper jncia, jncis, Vmware VCP-410,certification practice exams and so on.We are committed to give full refund to candidates if they fail the exam with use of our products.And we are confident to make such a guarantee. Buy Best Practice Exam,high-quality ,100% Guarantee ,Pls contact me,Mail:Sales@passguide.com

P4S Free Downloads

Type	Exam Braindumps	New Questions & Answers	Latest Updated	Available link
	All Pass4sure's Exam Pack	858	1 days ago	Download Free Testing Engines