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?

A.
Use CHECK constraints.

B.
Use an AFTER trigger.

C.
Use an INSTEAD OF trigger.

D.
Disable the foreign keys during the import process.