Apex domains cannot have CNAME records.
Question and response
Question
dig my-hosts.net. NS
Answer
my-hosts.net. 3 NS ns-497.awsdns-62.com.
my-hosts.net. 3 NS ns-1350.awsdns-40.org.
my-hosts.net. 3 NS ns-559.awsdns-05.net.
my-hosts.net. 3 NS ns-1696.awsdns-20.co.uk.
Authority
The response has no authority records.
Additional
. 0 OPT ; payload 1232, xrcode 0, version 0, flags 0