You have the following code in a cell in an Azure Synapse notebook.
# insert command here
new_rows = [('WA',2,45000), ('WA',35,65000),('WA',50,85000)]
demo_df = spark.createDataFrame(new_rows, ('state', 'age', 'salary'))
demo_df.createOrReplaceTempView('demo_df')
You need to replace the comment on the first line of the code with the correct magic command. Which magic command should you use?

Question

Accepted Answer

B. %pyspark In Azure Synapse notebooks, the `%pyspark` magic command can be used as the first line of a cell to specify that the entire cell's content should be executed as PySpark code, overriding the notebook's default language. This allows the subsequent PySpark code, such as `spark.createDataFrame`, to run correctly within that cell.

Answer

A. %%pyspark While `%%pyspark` is a common cell magic command in Jupyter-like environments to specify PySpark, for the specific context of Azure Synapse notebooks when placed as the first line to declare the cell's language, `%pyspark` is the expected magic command as per the correct answer.

Answer

C. %%spark `%%spark` is used to specify that a cell should be executed using the Spark (Scala) language, not PySpark.

Answer

D. %%sql `%%sql` is used to specify that a cell should be executed using SQL, not PySpark.

You have the following code in a cell in an Azure Synapse notebook. insert command here new_rows = [('WA',2,45000), ('WA',35,65000),('WA',50,85000)] demo_df = spark.createDataFrame(new_rows…

Question

insert command here

Options

How the community answered

Why each option

Topics

Community Discussion