Using the data from Table 6-5, you need to partition the table into three divisions, one for employees who make less than $50,000, one for employees who make $50,001 to $70,000, and one for employees who make $70,0001 and higher. Place the following steps in order to create a partition for this table.

Using the data from Table 6-5, you need to partition the table into three divisions, one for employees who make less than $50,000, one for employees who make $50,001 to $70,000, and one for employees who make $70,0001 and higher. Place the following steps in order to create a partition for this table.

Using the data from Table 6-5, you need to partition the table into three divisions, one for employees who make less than $50,000, one for employees who make $50,001 to $70,000, and one for employees who make $70,0001 and higher. Place the following steps in order to create a partition for this table.


D – Choose a partition column and value.
C – Add filegroups.
B – Create a partition function.
A – Create a partition scheme.

(First, you have to plan the partition and choose a column. Next, you need to make sure you have enough filegroups in the database to handle the partitions. After you have that, you can create a partition function, and then you can create the partition scheme.)