The Prince of Wales has flown a drone and fired a sniper rifle during a training session with the Welsh Guards.