Optical microcavities have widely been employed to enhance either the optical excitation or the photon emission processes for boosting light-matter interactions at the nanoscale. When both the excitation and emission processes are simultaneously facilitated by the optical resonances provided by the microcavities, as referred to the dual- resonance condition in this article, the performances of many nanophotonic devices approach to the optima. In this work, we present versatile accessing of dual-resonance conditions in deterministically coupled quantum-dot (QD)-micropillars, which enables emission from neutral exciton (X)—charged exciton (CX) transition with improved single-photon purity. In addition, the rarely observed up-converted single-photon emission process is achieved under dual-resonance conditions. We further exploit the vectorial nature of the high-order cavity modes to significantly improve the excitation efficiency under the dual-resonance condition. The dual-resonance enhanced light-matter interactions in the quantum regime provide a viable path for developing integrated quantum photonic devices based on cavity quantum electrodynamics (QED) effect, e.g., highly efficient quantum light sources and quantum logical gates.