YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDworksintheinstance.TheDworksdatabasehasatablenamedOrderthings.TheOrderthingstableispartitionedontheOrderIdcolumn.Thefirstpartitioncontainsintegervaluesgreaterthan100,000,whilethesecondpartitioncontainsintegervaluesbetween1and100,000.Youhavetoaddanewpartition.Thenewpartitionshouldcontainintegervaluesgreaterthan200,000.Whatshouldyoudo?（）A.A new partition function should be created B.You should change the existing partition scheme C.You should use a Merge clause to change the existing partition function D.You should use a Split clause to change the existing partition function

单项选择题

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. The Dworks database has a table named Orderthings. The Orderthings table is partitioned on the OrderId column. The first partition contains integer values greater than 100,000, while the second partition contains integer values between 1 and 100,000. You have to add a new partition. The new partition should contain integer values greater than 200,000. What should you do? （）

A.A new partition function should be created
B.You should change the existing partition scheme
C.You should use a Merge clause to change the existing partition function
D.You should use a Split clause to change the existing partition function

MCTS(70-432)