Microsoft
70-432 · Question #4
70-432 Question #4: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #4. The question stem and answer options stay visible for context.
Question
You are the administrator of a SQL Server 2008 instance with a database named Dworks. The table below shows the two tables of the Dworks database: There are two partitions in the BillHistory table. Partition1 is empty while partition2 contains all data. You intend to move data from partition2 to the appropriate partition of the BillHistory table. Partions2 contains data for the oldest month of the Bills table. You are going to develop a process to achieve this. You have to make sure that at the end of every month the process can be repeated.
Options
- AAlter the partition function of the BillHistory table by using the split option.
- BAlter the partition function of the Bills table by using the split option.
- CAlter the partition function of the BillHistory table by using the split option.
- DAlter the partition function of the Bills table by using the split option.
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 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.