ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam
Go to Exam

Exam DP-600 topic 1 question 15 discussion

Actual exam question from Microsoft's DP-600
Question #: 15
Topic #: 1
[All DP-600 Questions]

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 Hide Answer
Suggested Answer: CD 🗳️
by olavrab8 at Feb. 13, 2024, 11:46 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
mtroyano
Highly Voted 1 year, 1 month ago
Selected Answer: CD
Notebook only accepts the languages: PySpark, Spark, Spark SQL and SparkR
upvoted 18 times
DarioReymago
10 months, 3 weeks ago
yes but you can use "%%sql" in a notebook
upvoted 4 times
dev2dev
10 months, 1 week ago
that indicates to use spark sql language.
upvoted 6 times
testtaker45
3 months, 1 week ago
Thank you for that. I had the same question DarioReymago had.
upvoted 1 times
...
...
...
...
Vulkany
Most Recent 3 months, 1 week ago
Selected Answer: CD
Notebook only accepts the languages: PySpark, Spark, Spark SQL and SparkR
upvoted 1 times
...
NRezgui
4 months ago
Selected Answer: CD
PySpark, Spark
upvoted 1 times
...
shorymor
5 months ago
Selected Answer: CD
Notebook only accepts the languages: PySpark, Spark, Spark SQL and SparkR
upvoted 1 times
...
Rakesh16
5 months, 1 week ago
Selected Answer: CD
Spark SQL and PySpark
upvoted 1 times
...
jass007_k
6 months ago
Its C and D
upvoted 1 times
...
gtc108
10 months, 1 week 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 2 times
...
Gab13
10 months, 2 weeks ago
Selected Answer: CD
Notebook only accepts the languages: PySpark, Spark, Spark SQL and SparkR
upvoted 2 times
...
DarioReymago
10 months, 3 weeks 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
5 months, 3 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
11 months, 3 weeks 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
...
rmeng
11 months, 4 weeks ago
Selected Answer: CD
https://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/tutorial-score-model-predict-spark-pool
upvoted 1 times
...
David_Webb
1 year, 2 months ago
Selected Answer: CD
Using Fabric notebook, thus must be C and D.
upvoted 1 times
...
BrandonPerks
1 year, 2 months ago
The mention of Fabric Notebook, gives the hint to using Spark. Thus I went with CD
upvoted 1 times
...
Momoanwar
1 year, 2 months ago
Selected Answer: CD
C & d in notebook
upvoted 2 times
...
wojciech_wie
1 year, 2 months ago
CD - https://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/tutorial-score-model-predict-spark-pool
upvoted 2 times
...
olavrab8
1 year, 2 months ago
Selected Answer: CD
Answer CD Correct T-SQL Cannot be used, nor DAX
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago