MCSD Analyzing Requirements and Defining .NET Solution Architectures Exam Cram 2 (Exam 70-300)

by Cornish, Randy; Moore, Thomas; Pavoni, Don; Rockenbach, Eric; Tittel, Ed

• ISBN13: 9780789729293
• ISBN10: 0789729296
• Edition: CD
• Format: Paperback w/CD
• Copyright: 2003-01-01
• Publisher: Que Pub

Summary

bull; Published under the direction of Series Editor Ed Tittel, the leading authority on certification and the founder of The Exam Cram Method series bull; CD-ROM features PrepLogic Practice Tests bull; Exam Cram 2 is Cramsession Approved Study Material

Table of Contents

Introduction	xxii
Self-Assessment	xxvii
Master Case Study	1	(1)
Billington Pharmaceuticals	1	(6)
Background	1	(1)
Problem Statement	2	(1)
Current System	2	(1)
Envisioned System	3	(4)
Envisioning the Solution	7	(30)
Case Study: Setsko, Inc.	8	(3)
Background	8	(1)
Problem Statement	8	(1)
Current System	9	(1)
Envisioned System	10	(1)
Establishing a Proposed Solution	11	(6)
Define the Problem	11	(3)
Propose a Solution	14	(3)
Assessing the Solution's Feasibility	17	(3)
Is the Solution Feasible from a Business Perspective?	18	(1)
Is the Solution Feasible from a Technical Perspective?	18	(1)
Is the Solution Feasible from a Resource Perspective?	19	(1)
Assessing the Need for Change	20	(1)
Managing Risks	20	(4)
Sources of Risks	21	(1)
Risk Management: The MSF Process	21	(3)
Summary	24	(2)
Practice Questions	26	(9)
Need to Know More?	35	(2)
Gathering and Analyzing Business Requirements	37	(30)
The Current Business State	38	(7)
Analyzing Business Processes	38	(2)
Organizational Structure	40	(2)
Industry Position	42	(1)
Vertical Market Position	43	(1)
Personnel and Training	43	(1)
Political Climate	44	(1)
Regulatory Requirements	45	(1)
Analyzing Business Requirements for the Solution	45	(13)
Identify System Features	46	(1)
Gather Business Requirements	47	(2)
Identify Internal and External Dependencies	49	(1)
Define Data Requirements	50	(3)
Create Data Flow Diagrams	53	(5)
Summary	58	(2)
Practice Questions	60	(5)
Need to Know More?	65	(2)
Gathering and Analyzing User Requirements	67	(18)
Unified Modeling Language	68	(4)
Usage Scenarios	72	(1)
Developing World-Ready Applications	73	(5)
Globalization	74	(2)
Localization	76	(2)
Practice Questions	78	(5)
Need To Know More?	83	(2)
Gathering and Analyzing Operational and Infrastructure Requirements	85	(26)
Performance	86	(1)
Availability	87	(2)
Security	89	(3)
Scalability	92	(2)
Scaling Up and Scaling Out	92	(2)
Maintainability	94	(2)
Accessibility	96	(2)
Deployment	98	(2)
Extensibility	100	(1)
Hardware, Software, and Network Infrastructure Requirements	101	(2)
Practice Questions	103	(6)
Need To Know More?	109	(2)
Developing Specifications	111	(38)
Developing System Specifications	112	(1)
The Development Strategy	113	(21)
Auditing and Logging System Activity	114	(2)
Appropriate Error Handling	116	(2)
Handling Different Error Types	118	(1)
Integration to Leverage Investment	119	(1)
Globalization to Deploy to the World	119	(1)
Localization and Localizability	120	(1)
Data Storage	121	(2)
State Management	123	(7)
Deployment Strategies to Get the Product Out There	130	(4)
Development of the Security Strategy	134	(7)
Data Privacy	134	(3)
Operations Strategy	137	(1)
Planning the System Support	138	(1)
Tests, Tests, and More Tests	139	(1)
Preaching to the ``Converted''	139	(2)
Practice Questions	141	(6)
Need to Know More?	147	(2)
Creating the Conceptual Design	149	(26)
The Concept As a Model	150	(8)
Beginning with the Facts---It's Elementary, My D(ea)r Watson	151	(2)
Population Checks for Facts	153	(2)
Focus ORM Modeling on Entities	155	(3)
Applying Constraints to the Model	158	(8)
Identifying Uniqueness	160	(1)
What Is Optional? What Is Required?	161	(2)
Design and Development of Data Rules	163	(2)
Constraining a Ring Around the Rosies	165	(1)
Validate the Conceptual Design	166	(1)
What About the DBMS?	166	(2)
Summary	168	(1)
Practice Questions	169	(5)
Need to Know More?	174	(1)
Creating the Logical Design	175	(50)
It's Only Logical	176	(33)
Choosing the Correct Architectural Model	176	(5)
Auditing and Logging	181	(4)
Exception Handling	185	(1)
Internationalization, Globalization, and Localization	186	(1)
Accessibility	187	(1)
Security	188	(4)
Data Access Layer (DAL)	192	(1)
Business Logic Layer (BLL)	192	(1)
User Services Layer (USL)	193	(3)
Services and Components	196	(1)
Managing State	197	(3)
Synchronous Versus Asynchronous	200	(2)
Neither Here nor There	202	(7)
Do You Validate?	209	(4)
Does the Logical Design Meet the Business Requirements for ``Pass Made''?	209	(3)
Validate Against Usage Scenarios	212	(1)
Create a Proof-of-Concept Deliverable	212	(1)
Summary	213	(1)
Practice Questions	214	(9)
Need to Know More?	223	(2)
Creating the Logical Data Model	225	(30)
Data Modeling and Logical Data Design	226	(4)
Entity Relationship Modeling	227	(2)
Business Rules	229	(1)
Defining Tables and Columns	230	(5)
Defining Attributes/Columns	232	(1)
Defining Primary and Foreign Keys	233	(2)
Normalizing Tables	235	(3)
First Normal Form	235	(1)
Second Normal Form	235	(1)
Third Normal Form	236	(1)
Fourth and Fifth Normal Forms	236	(1)
Denormalization	236	(2)
Defining Relationships	238	(3)
One-to-One Relationship	238	(1)
One-to-Many Relationship	238	(1)
Many-to-Many Relationship	239	(1)
Identifying Relationships	239	(2)
Defining the XML Schema	241	(5)
Schema Versus DTD	241	(1)
Parts of a Schema Document	242	(3)
Namespaces and Other Schema Content	245	(1)
Summary	246	(1)
Practice Questions	247	(6)
Need to Know More?	253	(2)
Creating the Physical Design	255	(42)
Case Study: Book Seller, Inc.	257	(2)
Background	257	(1)
Problem Statement	257	(1)
Current System	257	(1)
Envisioned System	258	(1)
Let's Get Physical	259	(27)
Auditing and Logging	260	(2)
Exception Handling	262	(3)
Integration and Interoperability	265	(1)
Security	266	(4)
Business Services	270	(5)
User Services	275	(7)
Data Services and Components	282	(2)
Managing and Configuring State	284	(2)
Summary	286	(2)
Practice Questions	288	(7)
Need to Know More?	295	(2)
Deploying and Maintaining the Application	297	(30)
Case Study: Book Seller, Inc.	299	(1)
Review	299	(1)
Creating the Physical Deployment Design	299	(8)
Deployment	300	(3)
Licensing	303	(1)
Data Migration	304	(1)
Upgrading	305	(2)
Creating the Physical Design for Maintenance	307	(2)
Application Monitoring	307	(1)
Windows Management Instrumentation	308	(1)
Creating the Physical Design for the Data Model	309	(3)
Indexing	309	(2)
Partitions	311	(1)
Denormalization	312	(1)
Do You Validate?	312	(5)
Does Your Physical Design Meet the Business Requirements for PASS MADE?	313	(3)
Validating Against Usage Scenarios	316	(1)
Creating a Proof-of-Concept Deliverable	317	(1)
Summary	317	(2)
Practice Questions	319	(7)
Need to Know More?	326	(1)
Creating Standards and Processes	327	(32)
Case Study: Charles Laboratories, Allergy Products Division	328	(2)
Background	328	(1)
Problem Statement	328	(1)
Current System	329	(1)
Envisioned System	329	(1)
Establishing Standards for the Team	330	(11)
Documentation Standards	331	(1)
Coding Standards	331	(7)
Code Review Standards	338	(1)
User Interface Standards	339	(1)
Testing Standards	340	(1)
Establishing Processes for the Team	341	(6)
Testing Processes	341	(1)
Documentation Review Processes	342	(1)
Code Review Processes	343	(1)
Build Processes	343	(1)
Issue Tracking Processes	343	(1)
Source Code Management Processes	344	(1)
Change Management Processes	344	(1)
Release Management Processes	345	(1)
Maintenance Processes	345	(1)
What Are Enterprise Templates?	345	(2)
Measuring Quality	347	(2)
Project Control Metrics	347	(1)
Organizational Performance Metrics	347	(1)
Return on Investment Metrics	348	(1)
Summary	349	(1)
Practice Questions	350	(7)
Need to Know More?	357	(2)
Tips for Analyzing a Case Study	359	(20)
The Seven Objective Areas	360	(1)
Case Study: BCS, Part 1	361	(4)
Envisioning the Solution	362	(1)
Requirements (Business, User, Operational)	363	(1)
Developing Specifications	364	(1)
Conceptual Design	365	(1)
Case Study: BCS, Part 2	365	(4)
Logical Design	366	(2)
Physical Design	368	(1)
Case Study: BCS, Part 3	369	(2)
Standards and Processes	370	(1)
Pass Made	371	(3)
Performance	372	(1)
Availability	372	(1)
Security	373	(1)
Scalability	373	(1)
Maintainability	374	(1)
Accessibility	374	(1)
Deployability	374	(1)
Extensibility	374	(1)
A Word About the Unique Question Styles on the Exam	374	(1)
``Drag and Drop'' (Boxes and Lines)	374	(1)
Build a Tree	375	(1)
Ordered List	375	(1)
Choose the Correct Exhibit	375	(1)
And in Closing, I Would Just Like to Say...	375	(2)
Summary	377	(2)
Practice Exam 1	379	(14)
Case Study: GWA Wines	379	(3)
Background	379	(1)
Problem Statement	380	(1)
Current System	380	(1)
Envisioned System	381	(1)
Exam Questions	382	(11)
Answers to Practice Exam 1	393	(8)
Practice Exam 2	401	(14)
Case Study: XYZ Corp.	401	(3)
Background	401	(1)
Problem Statement	402	(1)
Current System	402	(1)
Envisioned System	403	(1)
Exam Questions	404	(11)
Answers to Practice Exam 2	415	(8)
Appendix A What's on the CD?	423	(2)
The PrepLogic Practice Exams, Preview Edition	423	(1)
An Exclusive Electronic Version of the Text	424	(1)
Appendix B Using the PrepLogic Practice Exams, Preview Edition Software	425	(8)
The Exam Simulation	425	(1)
Question Quality	426	(1)
The Interface Design	426	(1)
The Effective Learning Environment	426	(1)
Software Requirements	426	(1)
Installing PrepLogic Practice Exams, Preview Edition	427	(1)
Removing PrepLogic Practice Exams, Preview Edition from Your Computer	427	(1)
Using PrepLogic Practice Exams, Preview Edition	428	(1)
Starting a Practice Test Mode Session	428	(2)
Starting a Flash Review Mode Session	429	(1)
Standard PrepLogic Practice Exams, Preview Edition Options	429	(1)
Seeing Time Remaining	430	(1)
Getting Your Examination Score Report	430	(1)
Reviewing Your Exam	430	(1)
Contacting PrepLogic	430	(1)
Customer Service	431	(1)
Product Suggestions and Comments	431	(1)
License Agreement	431	(2)
Glossary	433	(16)
Index	449