CertInside 70-447
Http://www.CertInside.com CertInside Help you pass any IT Exams
Microsoft 70-447
MCDBA Skills to MCITP Database Administrator by using
Microsoft SQL Server 2005
Q&A v 3.32
http://www.CertInside.com/
CertInside,The Most Realistic Practice Exams!
CertInside 70-447
Http://www.CertInside.com CertInside Help you pass any IT Exams
1. BACKGROUND
Company Overview
Southridge Video is a video rental company. The company has a main office and 250 video rental locations in North
America. It also rents videos over the Internet, with delivery by mail.
Planned Changes
The company plans to develop a new mission-critical accounts database at the main office to maintain account
information for the Internet rentals business. This database must automatically fail over when the primary server fails. In
addition, the company wants to configure an additional server so that incorrect updates and deletions can be corrected
using the information on the additional server. No single server failure should prevent the ability to correct data errors.
Four new server computers will be available for this mission-critical accounts database.
A new replication system will be implemented so that store employees can view the list of videos that are available at
other company stores within 20 miles. Store employees should be able to update only their own store??s records.
Problem Statements
The database named rental_history is extremely large and is becoming slower as it increases in size. Investigation
revealed that the appropriate indexes already exist in this database. The most common report includes the customer name
and city from the customer table; the store name, city, and store number from the store table; the rental date from the
store table; the rental date from the rental table; and the video name and genre from the videotitle table. Query statistics
indicate that the joins that are requir