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?
A. Create a file watcher and an event-based job for bulk insert and then create another job to rebuild indexes on the table.
B. Create a file watcher for the bulk inserts and then create a job to rebuild indexes.
C. Create a job array and add a job for bulk insert and a job to rebuild indexes to the job array.
D. 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.