I recommend taking a mooring at Diamond Cay as it is protected in all weather conditions including a north swell. Foxy's Taboo for dinner and happy hour at the B-Line bar.

I did see moorings at Sandy Cay, but wasn't close enough to tell if they were NPT daytime moorings or overnight ones; I suspect the former.