You are a database developer. You plan to design a database solution by using SQL Server 2008. The database supports a Web site and captures user interactions. These interactions are stored in the Activity table of the User_Activity database. Data older than six months is archived to the Activity table of the Archive_Activity database on a different instance of SQL Server 2008. The structure of the Activity table is as shown in the following table.
You plan to design a solution that allows a single query to generate a report that summarizes user interactions for the last 12 months. You need to ensure that the solution is implemented. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A.
Create a partition function and a partition scheme.
B.
Modify the Activity tables to use the partition scheme.
C.
Move the archived data back to the User_Activity database.
D.
Create a view by using the UNION ALL clause to retrieve data from the two Activity tables.
E.
Create CHECK constraints on the two Activity tables to limit the values in the activity_date column to an exclusive range.