Microsoft
70-451 · Question #73
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…
The correct answer is A. Create a RANGE RIGHT partition function by using the values 20051231, 20071231. See the full explanation below for the reasoning.
Question
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?
Options
- ACreate a RANGE RIGHT partition function by using the values 20051231, 20071231,
- BCreate a RANGE LEFT partition function by using the values 20051231, 20071231,
- CCreate a RANGE LEFT partition function by using the values 20051231, 20071231,
- DCreate a RANGE RIGHT partition function by using the values 20051231, 20071231,
How the community answered
(62 responses)- A84% (52)
- B8% (5)
- C3% (2)
- D5% (3)
Community Discussion
No community discussion yet for this question.