It's the mobile processors. Later versions of the Surface Pro 2 had the i5-4300U and Dell has the Venue 11 Pro 7130 with the i5-4300Y processors. Both feature the vPro technology, although earlier versions of the Surface Pro 2 and other versions of the Core Venue 11 Pros had processors without vPro. I've read that Dell support said that vPro processors didn't support Connected Standby and even Surface Pro 2 users reported that Connected Standby didn't work properly either due to poor battery life.
The Microsoft KB seems to suggest that with all the virtualization technology turned on, that Connected Standby isn't available, but that doesn't state that it doesn't exist on those processors.
Perhaps neither Microsoft nor Dell put in the proper components for Connected Standby to work properly even if the processor supported the sleep state for Connected Standby, but I still wonder if the state exists within the processor and would it possibly work again if all the virtualization settings were disabled in the BIOS.