You are a database developer. You plan to design a database solution by using SQL Server
2008. The database will contain a table named Claims. The Claims table will contain a large
amount of data. You plan to partition the data into following categories: • Open claims •
Claims closed before January 1, 2005 • Claims closed between January 1, 2005 and
December 31, 2007 • Claims closed from January 1, 2008 till date The close_date field in
the Claims table is a date data type and is populated only if the claim has been closed. You
need to design a partition function to segregate records into the defined categories. What
should you do?
A.
Create a RANGE LEFT partition function by using the values 20051231, 20071231, and
20080101.
B.
Create a RANGE LEFT partition function by using the values 20051231, 20071231, and
NULL.
C.
Create a RANGE RIGHT partition function by using the values 20051231, 20071231, and
20080101.
D.
Create a RANGE RIGHT partition function by using the values 20051231, 20071231, and
NULL.