Yes, the adapter is passive, and doesn't play a role.
Yes, the SSD needs onboard OP ROM to show up in BIOS/ work as boot drive
Yes, the kingston and asus adapter should work.
keep in mind that only ACHI SSD's will work, as the X79 does not support NVME.