Avanade Interview Question

What considerations should be made with respect to database transactions?