When there is a Real Estate Agent and a Transaction Coordinator, do we both have to complete the questionnaire?

No. While the option will initially be available to you both, only one of you needs to complete it. Once one of you begins to answer the questions, the questionnaire will not appear in the other party.