Microsoft
70-451 · Question #53
70-451 Question #53: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #53. The question stem and answer options stay visible for context.
Question
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.)
Exhibit
Options
- ACreate a partition function and a partition scheme.
- BModify the Activity tables to use the partition scheme.
- CMove the archived data back to the User_Activity database.
- DCreate a view by using the UNION ALL clause to retrieve data from the two Activity tables.
- ECreate CHECK constraints on the two Activity tables to limit the values in the activity_date
Unlock 70-451 to see the answer
You've previewed enough free 70-451 questions. Unlock 70-451 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.