Web the simple answer to the question is no, you can’t retake the quiz if you’ve already taken it on that account.
Wizarding world sorting hat quiz ravenclaw
My wizarding world house quiz
Wizarding world quiz for wand