Can't comment on the Q7 directly but my TT with AWD does fine in the snow and rain, I would imagine the Q7 would do well. No real complaints about it, it has been a great vehicle.
It's horrible in the snow.
Even pulling the parking brake on during a turn will barely induce a slide.
Run up to 30-40 and spin the wheel and all it does is turn