Microsoft
70-451 · Question #19
70-451 Question #19: Real Exam Question with Answer & Explanation
The correct answer is C. Use an INSTEAD OF trigger.. See the full explanation below for the reasoning.
Question
You are a database developer. You create a database that uses SQL Server 2008 in an enterprise environment. You plan to import data from an external source into a table. You need to ensure that the following tasks are accomplished: - The import is successfully completed even if it encounters rows that fail foreign key constraints. - The rows that fail the foreign key constraints during import are inserted into a separate table. What should you do?
Options
- AUse CHECK constraints.
- BUse an AFTER trigger.
- CUse an INSTEAD OF trigger.
- DDisable the foreign keys during the import process.
Community Discussion
No community discussion yet for this question.