American Express Interview Question

When does one use stored procedure vs Dynamic SQL while working with RDBMS?