Discuss the trade-offs involved in selecting a database for a high-transaction environment at Microsoft.