In addition, instead of always initializing a transaction's storage
backend using the round-robin selection, pick Transient when we know
in advance that beresp will be uncacheable.

Closes #2533