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 view by using the UNION ALL clause to retrieve data from the two Activity
tables.
B.
Create CHECK constraints on the two Activity tables to limit the values in the
activity_date column to an exclusive range.
C.
Create a partition function and a partition scheme.
D.
Modify the Activity tables to use the partition scheme.
E.
Move the archived data back to the User_Activity database.