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.