Another great question Steve!
I have to agree with those who've already responded with "It depends." That's not a cop-out, it's a valid question and each business needs to evaluate that question and the regularly review the decisions.
:{>
Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics