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.
What type of view should you implement?
A.
Partitioned views.
B.
Replication views.
C.
Indexed views.
D.
Distributed partitioned views.
Explanation:
Distributed partitioned views allow you to partition data in the Customers table into smaller tables based on the different offices, and you can distribute the tables across the database servers in each office. This also allows the servers to share the query processing load.
Incorrect Answers:
A: Partition views reside on a single server while distributed partitioned views can be distributed across the database servers in each office. This allows the servers to share the query processing load and greatly improves performance.
B: Replication views do not improve performance.
C: Indexed views are used to improve performance of queries run against a view but you can achieve even better performance by using distributed partitioned views. Distributed partitioned views allow the three database servers to share the query processing load.
Reference:
Microsoft SQL Server 2005 Books Online (2007), Index: views [SQL Server]