Exam DP-203 topic 2 question 108 discussion

Actual exam question from Microsoft's DP-203

Question #: 108
Topic #: 2

HOTSPOT
-

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.

Show Suggested Answer

Suggested Answer:

by Azure_2023 at June 13, 2023, 8:32 a.m.

Comments

Submit Cancel

Azure_2023

Highly Voted 1 year, 4 months ago

Correct https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/synapse-spark-sql-pool-import-export?tabs=scala%2Cscala1%2Cscala2%2Cscala3%2Cscala4%2Cscala5

upvoted 8 times

efeee333

8 months, 1 week ago

agreed

upvoted 2 times

...

kkk5566

Most Recent 1 year, 1 month ago

%%spark && df.write.synapsesql

upvoted 3 times

...

alegiordx

1 year, 3 months ago

Correct, also according to this link https://microsoftlearning.github.io/DP-203-Data-Engineer/Instructions/Labs/LAB_04_data_warehouse_using_apache_spark.html ******* %%spark // Make sure the name of the dedcated SQL pool (SQLPool01 below) matches the name of your SQL pool. val df = spark.sqlContext.sql("select * from top_purchases") df.write.synapsesql("SQLPool01.wwi.TopPurchases", Constants.INTERNAL)