The settings control how the card interacts with the sleep signal. The default behavior for Nvidia is to do nothing which results in memory corruption when the computer wakes up again.
If you never put your computer to sleep, it'll never get that sleep signal so there's no real issue.
I'm not sure if I trust hibernation though, I've not tried it. Sleep has been just fine and doesn't eat too much power (like 5 watts for my desktop)
