CertInside 70-442
Http://www.CertInside.com CertInside Help you pass any IT Exams
Microsoft 70-442
PRO:Design & Optimize Data Access by Using MS SQL Serv
2005
Q&A v 5.88
http://www.CertInside.com/
CertInside,The Most Realistic Practice Exams!
CertInside 70-442
Http://www.CertInside.com CertInside Help you pass any IT Exams
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-tim