You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. The SQL Server 2008 instance contains a database named CK_DB that has a
table named CK_Tbl that is partitioned on the ProID column.
The partitioning characteristics are as follows:
Partition 1 has integer values between 5 and smaller than 30,000.
Partition 2 has integer values greater than 30,000.
Due to the growth in business operations the Domain.com management foresees the need to
have a third partition in the table. You receive instructions to create a third partition on the table.
This partition must be able to include the integer values greater than 60,000.
What should you do?
A.
You should consider adjusting existing partition function through utilizing a Split clause.
B.
You should consider adjusting existing partition function through utilizing a Merge clause.
C.
You should consider adjusting existing partition scheme.
D.
D. You should consider developing a new partition function.