Sometimes the answer is so simple you just don't see it! Would this *just* provide fault tolerance (if one card goes down, it gives the next IP)? i.e. not load balance. Or does it alternate which IP it gives out to the client issuing the request?
Round-robin DNS will hand out the two IP addresses alternatively.
It is not proper load balancing, since it assumes that both NICs are equally charged which might not always be the case. Proper load balancing is hard to do.
It is not fault tolerant: if one of the NICs goes down, the DNS server will still hand out that NIC's IP address to clients half of the time, until it gets reconfigured. A script can run in the background, periodically check if the NICs are still alive and reconfigure the DNS server when necessary.
Cheers,
Eric.