Does the piece you get back move like a queen when the pawn crosses?

One may designate what piece one wants, but the queen is what one should choose as it is the most versatile.