This may sound like a naive question but Dealer NO HELP. Car is AWD- does that mean it is NOT 4WD? They don’t suggest AWD for Beach driving in Northern outer Banks (Cardova) North Carolina

I thought this would be a breeze now not so sure...

I want to make sure my car can make it in Sand Mode 12 miles on the beach to get to the House and 12 back to civilization.

I thought all RR sports where 4WDs. Maybe not.
Any advice and on if I am asking the car to do to much and on setting. Will have to drive close to the beach, close to the dunes , and drive over dunes to get to the house. Thanks in advance for ANY help!!