I think in general, you shouldn't have to worry about Kingston or Viking brands; I personally have a Kingston 512 SD card and it's been fine so far. I have heard that Viking is ok too.
Have you looked at Happycheesecake's SD guide found
here? Keep in mind that any card can fail, but hopefully if it does, you will have an up-to-date backup and have also chosen a brand with a good warranty.
:)