70-451 · Question #92
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…
The correct answer is C. Write one stored procedure that contains a MERGE statement to perform the INSERT. See the full explanation below for the reasoning.
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.
How the community answered
(39 responses)- A8% (3)
- B3% (1)
- C74% (29)
- D15% (6)
Community Discussion
No community discussion yet for this question.