What would you do to accomplish this?

You want to schedule a job to rebuild a table’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:

What would you do to accomplish this?

Options:

Create a file watcher and an event-based job for bulk insert and then create another job to rebuild indexes on the table.

Create a file watcher for the bulk inserts and then create a job to rebuild indexes.

Create a job array and add a job for bulk insert and a job to rebuild indexes to the job array.

Create an event-based job for the file arrival event, then create a job for bulk insert, and then create a job to rebuild indexes.

Correct Answer

The Correct Answer for this Question is

Create a file watcher and an event-based job for bulk insert and then create another job to rebuild indexes on the table.