AWD vs locking 4WD vs slipping 4WD vs Quatto ...
My former Nissan Frontier and my Jeepster both have locking 4WD. Just like a tractor, it will pretty much get you through anything. Designed to be used on wet, soft, slippery, sandy, etc surfaces but absolutely not on dry pavement. Modern Jeeps and many other vehicles have a slipping 4WD, often called full time 4WD, which powers all 4 wheels but allows the vehicle to turn on dry pavement without "hopping" during the turn. Both are worthy of off roading.
All Wheel Drive is sort of a computer controlled system that typically favors the front wheels but when the computer detects slipping will send power to the rear or cut off power to a specific wheel, etc, it works well but is not designed for real off road. Generally a lighter duty offering that works pretty well for vehicles that live on pavement.
Quattro is sort of a mechanical 4WD that slips like full time 4WD but also is enhanced by computers and is pretty darn amazing and exceedingly effective in lighter vehicles but too complicated for trucks. I have Quattro on both my Audi's and have driven through storms that had everything but Jeeps in the ditches with my Audi sedan. Quatto is simply amazing and the best system I've ever used for on road use.
My new Honda Ridgeline is an AWD. It has road tires. Today we got slush with snow over the top of it and the Ridgeline slipped right off the road on the first curve that I encountered. I'll admit I was testing it and went into the curve fast enough to test the system. I believe the AWD worked well enough but the road tires failed miserably in the slushy snow. Took the truck to an empty parking lot and tested it a bit there, while the Ridgeline is biased to front wheel drive, in "snow" mode it balances more toward all 4 wheels. Despite that, I was able to break the rear end loose in the parking lot while trying to slide the truck around but the AWD traction kicked in and kept it under reasonable control. As I said, pretty sure the weak link on this truck, for snow use, is the set of factory tires that it comes with. The tires simply are not designed for snow driving.