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.

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.

Accepted Answer

C. Alter the partition function of the BillHistory table by using the split option.

Answer

A. Alter the partition function of the BillHistory table by using the split option.

Answer

B. Alter the partition function of the Bills table by using the split option.

Answer

D. Alter the partition function of the Bills table by using the split option.

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…

Question

Options

How the community answered

Community Discussion