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. The Domain.com network contains a database server named Certkiller -DB01 B01. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company. The tables in the CK_Sales database are shown in the following database diagram.
The CK_Sales database currently uses a single filegroup. Domain.com decides to switch to commission-based salaries for its Sales staff. The manager of the Sales department will run queries against the Invoices table to calculate the commission for each sales person. To improved database performance, you decide to partition the Invoices table by SalesPersonID and store each partition in a separate filegroup. You also want to create a partitioned index for the Invoices table.
What should you do before you can create the partition scheme? (Each correct answer presents part of the solution. Choose two.)
A.
Create the partition function.
B.
Create the index.
C.
Create the filegroups.
D.
Create the table.
Explanation:
You need to create the partition function and the filegroups that you want to use in the partition scheme before you can create the partition scheme.
Incorrect Answers:
B, D: You can create the partition scheme before you create the tables and indexes.
Reference:
Microsoft SQL Server 2005 Books Online (2007), Index: partitions [SQL Server] Microsoft SQL Server 2005 Books Online (2007), Index: partitioned views [SQL Server]