Compacted clay sucks, and I've run into clay that had been compacted in multiple layers, and digging down to sticks and logs found wood that hadn't begun to decompose due to the lack of air.
Not sure what good a drainage test would do, compacted clay doesnt perc....
I'd dig the sand in as deep as I could, and hope for the best...
In that garden with the layers.... I never could get deep enough for the soil to drain.... It grew really nice wetland plants....
Eventually, additional wok was done... With heavy equipment on the garden (again!), and an auger was tried... Kind of useless, because after the auger, a bobcat was used to level everything out... Further compacting that mess....
Some people just won't listen....
Bye the bye, a tiller is useless in compacted soil.... Just bounces... Tiller won't work until you break up the soil, and then....you don't need the tiller....
I firmly believe that a tiller is probably one of the worst tools you can use on a garden.... it kills the worms, destroys soil tilth, kills the mycelium, and... Brings up the seeds to the surface where they can germinate.... So.... If you want weeds.... Run the tiller.... Other wise... Maybe just don't bother.
Go out there with a shovel and mattox, when the soil is moist.... Winter is a great time here.... Where you are... Probably now is fine.