Can I connect when a device is asleep, or powered off?

No, the device running RealVNC Server must be powered on and have an active network connection to be available for connections from RealVNC Viewer.