Microsoft
70-451 · Question #136
70-451 Question #136: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #136. The question stem and answer options stay visible for context.
Question
You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains a table that has a column defined as a smallint data type. The table is partitioned on has boundaries of 100 and 1,000. The table must be altered to contain the following partitions: < 100 >= 100 and < 400 >= 400 and < 700 >= 700 and < 1000 >= 1000 You need to alter the partition function to provide the required partitions. Which code fragment should you use?
Options
- AALTER PARTITION FUNCTION MyRangePF1 () SPLIT RANGE (399); GO ALTER
- BALTER PARTITION FUNCTION MyRangePF1 () SPLIT RANGE (400); GO ALTER
- CDROP PARTITION FUNCTION myRangePF1; GO
- DDROP PARTITION FUNCTION myRangePF1; GO
Unlock 70-451 to see the answer
You've previewed enough free 70-451 questions. Unlock 70-451 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.