Microsoft
70-432 · Question #98
70-432 Question #98: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #98. 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 AdventureWorks. The AdventureWorks database contains two tables as shown in the following table: 1. The Orders table contains a table partition for each month. 2. The OrderHistory table contains two table partitions; one partition contains all data and the other partition is empty. 3. You plan to develop a process to move data from the partition that contains data for the oldest month of the Orders table to the appropriate partition of the OrderHistory table. 4. You need to ensure that the process can be repeated at the end of every month. What should you do?
Options
- AAlter the partition function of the Orders table by using the split option.
- BAlter the partition function of the OrderHistory table by using the split option.
- CAlter the partition function of the Orders table by using the split option.
- DAlter the partition function of the OrderHistory 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.