Yes, BA sociology can be beneficial in your UPSC CSE preparation run. It is not that it is the only one subject which can be beneficial as you must have seen that most of the qualified students hail from Humanities ground.

In fact it is the optional paper which proves to be a king maker. I have seen various students opting for Philosophy or Anthropology inspite of having Engineering Background.

All the best!!