PrepAway - Latest Free Exam Questions & Answers

what should you do?

You intend to import data from an external source into a table. You must make sure that the tasks below are achieved:
* The rows that fail the foreign key constraints during import are inserted into a separate table.
* Even if the import encounters rows that fail foreign key constraints, it is successfully completed.
So what should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
An AFTER trigger has to be used

B.
CHECK constraints have to be used

C.
An INSTEAD OF trigger has to be used

D.
During the import process disable the foreign keys


Leave a Reply