Default Transient API behavior is to use Options API for storage and so behavior identical to options.
However if there is external object cache (declared by plugin or whatever) then they get stored using object cache functions instead.
So basically it will work in scope of current site, unless there are plugins that make it work otherwise.