Avanade interview question

why would you use a trigger verses a stored procedure