Microsoft
70-451 · Question #92
70-451 Question #92: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #92. The question stem and answer options stay visible for context.
Question
You are a database developer. You provide solutions by using SQL Server 2008 in an enterprise environment. Your online transaction processing (OLTP) database contains a tabled named SalesOrders. Your data warehouse contains a table named factBuyingHabits. The factBuyingHabits table has no indexes. You need to synchronize data between the two tables on a weekly basis. The synchronization process has the following requirements: - New records in the SalesOrders table are inserted in the factBuyingHabits table. - When a record is modified in the SalesOrders table, the modification is updated in the factBuyingHabits table. - Records that are deleted from the SalesOrders table are also deleted from the factBuyingHabits table. You need to design an appropriate synchronization solution. You want to achieve this goal by using minimum amount of coding and administrative efforts. What should you do?
Options
- ADesign an SSIS package each for the INSERT, UPDATE, and DELETE operations.
- BDesign a single SSIS package that uses the Slowly Changing Dimension task.
- CWrite one stored procedure that contains a MERGE statement to perform the INSERT,
- DWrite three stored procedures each for the INSERT, UPDATE, and DELETE operations.
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.