Most studies instead point to the importance of more general traits, like autonomy or a sense of competence (see, for example, the voluminous research literature on Self-Determination Theory for more on such findings).
Exceptional achievers always experience low levels of confidence and self-confidence, but they train hard and practice continually until they reach an acceptable level of competence.