You administer a SQL Server 2008 instance that contains a database named
AdventureWorks. The AdventureWorks database contains the OrderHistory table. The
OrderHistory table is partitioned on the OrderId column. The first partition contains integer
values between 1 and
100.000. The second partition contains integer values greater than 100.000. You need to
add a new partition that contains integer values greater than 200.000. What should you do?
A.
Create a new partition function.
B.
Alter the existing partition scheme.
C.
Alter the existing partition function by using a Split clause.
D.
Alter the existing partition function by using a Merge clause.