When you list multiple authoritative name servers for a domain at your registrar, queries are distributed amongst all listed name servers in a round robin fashion.
There is no way to configure an authoritative name server as a backup that only works when some other name server is unreachable.