How to combine the Questions JSON and Response JSON file using the PySpark notebook in Azure Synapse?

Hello everyone,

I have been assigned the task of combining the Questions and Responses JSON files and loading them into an SQL table in Azure Synapse. Has anyone here accomplished the same task and can share PySpark code?

Thank you in advance,