The purpose of an attack on the DNS is usually to poison the Recursive Resolver's cache. That is, to make the Recursive Resolver think that an IP address of a server belonging to the Attacker is the IP address of another website (a bank, for example). If an attack is successful it may misdirect a user to the Attacker's website, causing it to give away confidential information.