Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 15 discussion

Actual exam question from Microsoft's DP-600

Question #: 15
Topic #: 1

You have a Fabric tenant that contains a machine learning model registered in a Fabric workspace.
You need to use the model to generate predictions by using the PREDICT function in a Fabric notebook.
Which two languages can you use to perform model scoring? Each correct answer presents a complete solution.
NOTE: Each correct answer is worth one point.

A. T-SQL
B. DAX
C. Spark SQL
D. PySpark

Show Suggested Answer

Suggested Answer: CD 🗳️

by olavrab8 at Feb. 13, 2024, 11:46 a.m.

Comments

Submit Cancel

mtroyano

Highly Voted 1 year, 5 months ago

Selected Answer: CD

Notebook only accepts the languages: PySpark, Spark, Spark SQL and SparkR

upvoted 18 times

DarioReymago

1 year, 2 months ago

yes but you can use "%%sql" in a notebook

upvoted 4 times

dev2dev

1 year, 1 month ago

that indicates to use spark sql language.

upvoted 6 times

testtaker45

7 months ago

Thank you for that. I had the same question DarioReymago had.

upvoted 1 times

...

Vulkany

Most Recent 7 months ago

Selected Answer: CD

Notebook only accepts the languages: PySpark, Spark, Spark SQL and SparkR

upvoted 1 times

...

NRezgui

7 months, 3 weeks ago

Selected Answer: CD

PySpark, Spark

upvoted 1 times

...

shorymor

8 months, 3 weeks ago

Selected Answer: CD

Notebook only accepts the languages: PySpark, Spark, Spark SQL and SparkR

upvoted 1 times

...

Rakesh16

9 months ago

Selected Answer: CD

Spark SQL and PySpark

upvoted 1 times

...

jass007_k

9 months, 3 weeks ago

Its C and D

upvoted 1 times

...

gtc108

1 year, 1 month ago

https://learn.microsoft.com/en-us/fabric/data-science/tutorial-data-science-batch-scoring ou'll load the test dataset into a spark DataFrame and create an MLFlowTransformer object to generate batch predictions. You can then invoke the PREDICT function using one of following three ways: Transformer API from SynapseML Spark SQL API PySpark user-defined function (UDF)

upvoted 3 times

...

Gab13

1 year, 2 months ago

Selected Answer: CD

Notebook only accepts the languages: PySpark, Spark, Spark SQL and SparkR

upvoted 2 times

...

DarioReymago

1 year, 2 months ago

Selected Answer: AD

We can use Predict function with T-SQL: https://learn.microsoft.com/en-us/sql/t-sql/queries/predict-transact-sql?view=sql-server-ver16 But I cannot found the Predict function in Spark SQL. Is different to run a predict process in PySpark

upvoted 1 times

semauni

9 months, 2 weeks ago

The question asks to do this from a notebook. Spark SQL can be accessed from the notebook using the %%sql-command, while T-SQL cannot. Spark SQL, however, can also be used: https://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/tutorial-score-model-predict-spark-pool

upvoted 1 times

...

stilferx

1 year, 3 months ago

Selected Answer: CD

IMHO, the answer is C & D. Link is here: https://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/tutorial-score-model-predict-spark-pool Here, """You can call PREDICT three ways, using Spark SQL API, using User define function (UDF), and using Transformer API. """. That means, UDF = PySpark in our case.

upvoted 1 times

...