What should you do before you can create the partition scheme?
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.
exhibit What should you do before you can create the partition scheme? (Each correct answer presents part of the solution. Choose two.)