Microsoft
70-451 · Question #73
70-451 Question #73: Real Exam Question with Answer & Explanation
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,
Community Discussion
No community discussion yet for this question.