DP-203 Certification Practice Question #181

Question

You have an Azure subscription that contains an Azure Synapse Analytics workspace named workspace1. Workspace1 contains a dedicated SQL pool named SQLPool1 and an Apache Spark pool named sparkpool1. Sparkpool1 contains a DataFrame named pyspark_df.

You need to write the contents of pyspark_df to a table in SQLPool1 by using a PySpark notebook.

How should you complete the code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Accepted Answer

The official Synapse Spark connector for dedicated SQL pool exposes the `synapsesql` writer for DataFrame output, and Microsoft Learn also notes that `%%spark` is used when invoking the connector from other notebook language contexts. That matches the community?s answer exactly and is the intended syntax family for this question.

More DP-203 practice questions