Positive battery cable spark

What is your question?

I have a very faint spark when I connect the positive battery cable. When I connect it to a freshly charged battery all seems to be good but after the car sitting for several days the battery will drain and no longer start. I have read that a small about of spark may occur due to memory storage which I understand but should it completely drain the battery if vehicle is not used very often