We investigate analytically the asymptotic behavior of high-order spurious prolate spheroidal modes induced by a second-order local approximate DtN absorbing boundary condition (DtN2) when employed for solving high-frequency acoustic scattering problems. We prove that these reflected modes decay exponentially in the high frequency regime. This theoretical result demonstrates the great potential of the considered absorbing boundary condition for solving efficiently exterior high-frequency Helmholtz problems. In addition, this exponential decay proves the superiority of DtN2 over the widely used Bayliss-Gunsburger-Turkel absorbing boundary condition.