70-451 · Question #53
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…
The correct answer is 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. See the full explanation below for the reasoning.
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
How the community answered
(36 responses)- A3% (1)
- B11% (4)
- C6% (2)
- D81% (29)
Community Discussion
No community discussion yet for this question.