You want to schedule a job to rebuild atable's indexes after a bulk insert, which must be scheduled as soon as a file containing data arrives on the system. What would you do to accomplish this?

Question

Accepted Answer

A. Create a file watcher and an event-based job for bulk insert and then create another job to A file watcher detects the incoming file and raises an arrival event; an event-based job subscribes to that event to execute the bulk insert; a second dependent job then rebuilds the indexes - this three-component design ensures correct sequencing and full end-to-end automation.

Answer

B. Create a file watcher for the bulk inserts and then create a job to rebuild indexes. Creating only a file watcher and an index-rebuild job omits the event-based job that performs the bulk insert upon file arrival, leaving the bulk insert step unscheduled.

Answer

C. Create a job array and add a job for bulk insert and a job to rebuild indexes to the job array. Job arrays group jobs for batch processing but do not support event-based triggering on file arrival and do not enforce sequential dependency between the bulk insert and the index rebuild.

Answer

D. Create an event-based job for the filearrival event, then create a job for bulk insert, and then This option is truncated and incomplete, and does not describe a valid end-to-end solution that handles file arrival, bulk insert, and index rebuild in the correct sequence.

You want to schedule a job to rebuild atable's indexes after a bulk insert, which must be scheduled as soon as a file containing data arrives on the system. What would you do to accomplish this?

Question

Options

How the community answered

Why each option

Topics

Community Discussion