Flylib.com
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors:
Thomas Moore
BUY ON AMAZON
MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005
Table of Contents
Copyright
About the Author
Acknowledgments
We Want to Hear from You
Reader Services
Introduction
About the 70-431 Exam and Content Areas
How to Prepare for the Exam
What This Book Does
What This Book Does Not Do
About This Book
Self Assessment
SQL Server Implementation and Maintenance as an MCTS
Chapter 1. Installing and Configuring SQL Server 2005
Installing and Configuring SQL Server 2005
Exam Prep Questions
Chapter 2. Creating Database Objects
Creating and Defining Databases
Defining SQL Server Tables
SQL Server Programmability Objects
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 3. Implementing Database Objects
Data Querying and Reporting
Data Querying Using Full-Text Indexes
Using System Tables and Views
Changing What Is Already Stored
Removing Unwanted Data
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 4. Supporting the XML Framework
Managing XML Data
Other SQL Server XML Support
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 5. Data Consumption and Throughput
Importing and Exporting Data
Implementing Service Broker
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 6. Database Maintenance
SQL Server 2005 Database Maintenance
Performing Database Backups
Restoring Data from a Backup
Using Database Snapshots
Automating Maintenance with Job Scheduling
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 7. Monitoring SQL Server Performance
SQL Server Management Studio
Monitoring and Recording Performance
Using Windows System Monitor
Using SQL Server Profiler
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 8. Troubleshooting and Optimizing SQL Server
Data Analysis and Problem Diagnosis
Tuning the Database Structure
Server Configuration Maintenance
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 9. Implementing High Availability
High-Availability Solutions
Using Replication
Microsoft Analysis Services
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 10. Practice Exam 1
Exam Questions
Chapter 11. Answers to Practice Exam 1
Question 1
Question 2
Question 3
Question 4
Question 5
Question 6
Question 7
Question 8
Question 9
Question 10
Question 11
Question 12
Question 13
Question 14
Question 15
Question 16
Question 17
Question 18
Question 19
Question 20
Question 21
Question 22
Question 23
Question 24
Question 25
Question 26
Question 27
Question 28
Question 29
Question 30
Question 31
Question 32
Question 33
Question 34
Question 35
Question 36
Question 37
Question 38
Question 39
Question 40
Chapter 12. Practice Exam 2
Exam Questions
Chapter 13. Answers to Practice Exam 2
Question 1
Question 2
Question 3
Question 4
Question 5
Question 6
Question 7
Question 8
Question 9
Question 10
Question 11
Question 12
Question 13
Question 14
Question 15
Question 16
Question 17
Question 18
Question 19
Question 20
Question 21
Question 22
Question 23
Question 24
Question 25
Question 26
Question 27
Question 28
Question 29
Question 30
Question 31
Question 32
Question 33
Question 34
Question 35
Question 36
Question 37
Question 38
Question 39
Question 40
Appendix A. Suggested Readings and Resources
Chapter 1: Installing and Configuring SQL Server 2005
Chapter 2: Creating Database Objects
Chapter 3: Implementing Database Objects
Chapter 4: Supporting the XML Framework
Chapter 5: Data Consumption and Throughput
Chapter 6: Database Maintenance
Chapter 7: Monitoring SQL Server Performance
Chapter 8: Troubleshooting and Optimizing SQL Server
Chapter 9: Implementing High Availability
Appendix B. Accessing Your Free MeasureUp Practice Test
Appendix C. MeasureUp s Product Features
Multiple Testing Modes
Question Types
Random Questions and Order of Answers
Detailed Explanations of Correct and Incorrect Answers
Attention to Exam Objectives
Technical Support
Glossary
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors:
Thomas Moore
BUY ON AMAZON
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Setting Connection Pooling Options
Controlling the Names Used in a Strongly Typed DataSet
Determining the Differences in Data Between Two DataSet Objects
Combining Data in Tables from Heterogeneous Data Sources
Listing Tables in an Access Database
A Practitioners Guide to Software Test Design
Boundary Value Testing
Pairwise Testing
Section III - Testing Paradigms
Test Planning
When to Stop Testing
Developing Tablet PC Applications (Charles River Media Programming)
Obtaining the Tablet PC SDK
Creating an MP3 Player
Advanced Microsoft Agent
WMI and Hardware
Storing Ink in a Database
Cisco IOS in a Nutshell (In a Nutshell (OReilly))
Mapping Hostnames to IP Addresses
The Null Interface
EIGRP
Route Reflectors
Snapshot DDR
Cisco ASA: All-in-One Firewall, IPS, and VPN Adaptive Security Appliance
SNMP
Monitoring and Troubleshooting the Security Contexts
IPS Management Using ASDM
Cisco Remote-Access IPSec VPN Setup
Summary
Telecommunications Essentials, Second Edition: The Complete Global Source (2nd Edition)
The OSI Reference Model and the TCP/IP Reference Model
IP Services
The Migration to Optical Networking
Wireless Broadband
Spectrum Utilization
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies