The German pronunciation given by btn.com is wrong. Certainly, there MIGHT be Germans who pronounce Sofie "ZO-fee", but in general, we say: "zoh-FEE", emphasizing the second syllable. [noted -ed]
I just love it! My mom's name is Sonia and I want to name my future daughter after her and this is a perfect name, since my family is Scandinavian and German!