MCSE Microsoft® SQL Server 2000 Administration Readiness Review

Exam 70-228

Irfan Chaudhry, Dean Bartholomew

262 pages, parution le 01/04/2001

Ajouter à une liste

Indisponible

Résumé

Test your readiness for the MCP exam.

If you took Microsoft Certified Professional (MCP) Exam 70-228 today, would you pass? With the Readiness Review MCP exam simulation on CD-ROM, you get a low-risk, low-cost way to find out! This next-generation test engine delivers a set of randomly generated, 50-question practice exams covering real MCP objectives. You can test and retest with different question sets each time-and with automated scoring, you get immediate Pass/Fail feedback. More important, you get answers to these four critical questions:

What do MCP exam questions look like?
In what topic and skill areas am I proficient/deficient?
How should I focus my studies?
Am I ready for the real exam?

Use this Readiness Review to evaluate your proficiency with the skills and knowledge tested on Exam 70-228, including:

Installing and upgrading
Creating databases
Extracting and transforming data
Optimizing performance
Managing security
Troubleshooting system activity

After completing your practice sessions, use the companion book to review helpful explanations for all responses-right and wrong-and to identify areas for further study. Sharpen your test-taking skills, save valuable time and money, and build your confidence for the real exam with Readiness Review. It's the smart way to prep!

Contents

Welcome to Microsoft SQL Server 2000 Administration	ix
Before You Begin	x
Using the MCSE Readiness Review	xii
Exam Objectives Summary	xviii
Getting More Help	xx
OBJECTIVE DOMAIN 1: Installing and Configuring SQL Server 2000	1
Tested Skills and Suggested Practices	1
Further Reading	4
Objective 1.1: Install SQL Server 2000.	7
Questions	9
Answers	11
Objective 1.2: Upgrade to SQL Server 2000.	15
Questions	17
Answers	19
Objective 1.3: Create a linked server.	21
Questions	22
Answers	24
Objective 1.4: Configure SQL Mail and SQLAgentMail.	27
Questions	28
Answers	30
Objective 1.5: Configure network libraries.	33
Questions	35
Answers	37
Objective 1.6: Troubleshoot failed installations.	39
Questions	40
Answers	41
OBJECTIVE DOMAIN 2: Creating SQL Server 2000 Databases	45
Tested Skills and Suggested Practices	46
Further Reading	47
Objective 2.1: Configure database options for performance.	49
Questions	50
Answers	52
Objective 2.2: Attach and detach databases.	55
Questions	56
Answers	58
Objective 2.3: Create and alter databases.	61
Questions	62
Answers	64
Objective 2.4: Create and manage objects.	69
Questions	71
Answers	74
OBJECTIVE DOMAIN 3: Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases	77
Tested Skills and Suggested Practices	78
Further Reading	80
Objective 3.1: Optimize database performance.	83
Questions	85
Answers	88
Objective 3.2: Optimize data storage.	91
Questions	92
Answers	94
Objective 3.3: Modify the database schema.	97
Questions	99
Answers	100
Objective 3.4: Perform disaster recovery operations.	103
Questions	104
Answers	108
Objective 3.5: Perform integrity checks.	111
Questions	113
Answers	115
Objective 3.6: Troubleshoot transactions and locking by using SQL Profiler, SQL Server Enterprise Manager, or Transact-SQL.	117
Questions	118
Answers	120
OBJECTIVE DOMAIN 4: Extracting and Transforming Data with SQL Server 2000	123
Tested Skills and Suggested Practices	124
Further Reading	126
Objective 4.1: Set up Internet Information Services (IIS) virtual directories to support XML.	129
Questions	130
Answers	132
Objective 4.2: Import and export data.	135
Questions	137
Answers	139
Objective 4.3: Develop and manage Data Transformation Services (DTS) packages.	141
Questions	142
Answers	146
Objective 4.4: Manage linked servers.	149
Questions	151
Answers	152
Objective 4.5: Convert data types.	155
Questions	156
Answers	157
Objective 4.6: Configure, maintain, and troubleshoot replication services.	161
Questions	163
Answers	165
OBJECTIVE DOMAIN 5: Managing and Monitoring SQL Server 2000Security	169
Tested Skills and Suggested Practices	169
Further Reading	171
Objective 5.1: Configure mixed security modes or Windows Authentication.	175
Questions	177
Answers	178
Objective 5.2: Create and manage logons.	181
Questions	182
Answers	185
Objective 5.3: Create and manage database users.	189
Questions	190
Answers	192
Objective 5.4: Create and manage security roles.	195
Questions	196
Answers	198
Objective 5.5: Enforce and manage security by using stored procedures, triggers, views, and user-defined functions.	201
Questions	202
Answers	203
Objective 5.6: Set permissions in a database.	205
Questions	206
Answers	207
Objective 5.7: Manage security auditing.	211
Questions	212
Answers	213
OBJECTIVE DOMAIN 6: Managing, Monitoring, and Troubleshooting SQL Server 2000	215
Tested Skills and Suggested Practices	216
Further Reading	217
Objective 6.1: Create, manage, and troubleshoot SQL Server Agent jobs.	219
Questions	221
Answers	223
Objective 6.2: Configure alerts and operators by using SQL Server Agent.	227
Questions	229
Answers	230
Objective 6.3: Optimize hardware resource usage.	233
Questions	234
Answers	235
Objective 6.4: Optimize and troubleshoot SQL Server system activity.	237
Questions	239
Answers	241
GLOSSARY	243
INDEX	253

Caractéristiques techniques

	PAPIER
Éditeur(s)	Microsoft Press
Auteur(s)	Irfan Chaudhry, Dean Bartholomew
Parution	01/04/2001
Nb. de pages	262
Format	18,7 x 22,8
Couverture	Broché
Poids	595g
Intérieur	Noir et Blanc
EAN13	9780735612501

Avantages Eyrolles.com

Livraison à partir de 0,01 € en France métropolitaine

Paiement en ligne SÉCURISÉ

Livraison dans le monde

Retour sous 15 jours

+ d'un million et demi de livres disponibles

MCSE Microsoft® SQL Server 2000 Administration Readiness Review

Résumé

Caractéristiques techniques

Consultez aussi

MCSE Microsoft® SQL Server 2000 Administration Readiness Review