Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Microsoft 70-442
Title
: PRO:Design & Optimize
Data Access by Using MS
SQL Serv 2005
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1. BACKGROUND
company overview
Tailspin toys is a regional toy store chain,with stores in 30 cities.
Planned Changes
The company wants to add an online store to its chain of retail stores.A prototype of the online store was
developed by using SQL server 2000 .However,the IT manager wants to move to SQL Sever 2005
to
take advantage of its new features.
The IT manager plans to automate certain database maintenance operations,including scripting of
database objects,backup and restore activities ,and creation and maintenance of endpoints.
Problem Statement
The nightly processing of the sales data from each store executes very slowly.with the addition of the online
store,this performance must be improved in order to complete the processing within the allotted frame.
EXISTING ENVIRONMENT
Existing Application Environment
The prototype of the online store is experiencing poor concurrency.
Existing supporting Infrastructure
Currently,the point of sale(POS) system for the retail stores has a SQL Server 2000 database.Tailspin Toys
has an Enterprise Resource planning(ERP) system running on UNIX that must be able to communicate
with the online store's Inventory database.
BUSINESS REQUIREMENTS
General Application Solution Requirements
The company is developing an online store that is capable of displaying pictures,prices,and information on
products that are sold by Tailspin Toys.
Customers must be able to find out whether toys that are available online are also available at a physical
store for pickup.The store inventory for a selected store must be queried real-time as the individual toys are
displayed.Inventory quantities for a toy must all be displayed prior to processing the next toy.
Store managers often run reports that