PrepAway - Latest Free Exam Questions & Answers

Tag: Improve Database Performance SQL Server View

What type of view should you implement?

You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. Domain.com has its headquarters in Chicago and branch offices in Miami, and San Francisco. The Domain.com network contains three database servers named Certkiller -DB01, Certkiller -DB02, and Certkiller -DB03. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company. Transactional replication of the CK_Sales database is configured with Certkiller -DB01 as the Publisher and Certkiller -DB02 and Certkiller -DB03 are configured as Subscribers. Certkiller -DB01 is located at headquarters while Certkiller -DB02 is located in Miami and Certkiller -DB03 is located in San Francisco. The tables in the CK_Sales database are shown in the following database diagram.

The Customers table contains more than 200,000 rows. Domain.com uses a custom application to access data in the Customers table. Domain.com users in the Sales department at each office use the custom application to access and update data for the customers assigned to his or her office.
You want to improve database performance by implementing views on the Customers table.
exhibit What type of view should you implement?