nerdexam
Microsoft

70-451 · Question #19

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…

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.

How the community answered

(27 responses)
  • A
    4% (1)
  • B
    11% (3)
  • C
    78% (21)
  • D
    7% (2)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-451 Practice