70-432 · Question #107
You are the administrator of a SQL Server 2008 instance with a database named named Dworks. The table below shows the two tables of the Dworks database: There are two partitions in the BillHistory…
The correct answer is C. 1. Alter the partition function of the BillHistory table by using the split option. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance with a database named 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 toachieve this. You have to make sure that at the end of every month the process can be repeated. Which actions should you take?
Options
- A
- Alter the partition function of the BillHistory table by using the split option.
- B
- Alter the partition function of the Bills table by using the split option.
- C
- Alter the partition function of the BillHistory table by using the split option.
- D
- Alter the partition function of the Bills table by using the split option.
How the community answered
(42 responses)- A7% (3)
- B2% (1)
- C74% (31)
- D17% (7)
Community Discussion
No community discussion yet for this question.