DP-500 · Question #149
You have an Azure Synapse Analytics workspace that is connected to a data lake. You train an Open Neural Network Exchange (ONNX) model named Model1. You need to implement Model1. What should you do…
The correct answer is D. Score Model1 by using PREDICT(). To implement an ONNX model in Azure Synapse Analytics, the first step is typically to use the PREDICT() function to score the model against new data.
Question
Options
- AScore Model1 by using OPENJSON().
- BLoad Model1 into a binary variable.
- CLoad Model1 into a character variable.
- DScore Model1 by using PREDICT().
How the community answered
(40 responses)- B3% (1)
- C5% (2)
- D93% (37)
Why each option
To implement an ONNX model in Azure Synapse Analytics, the first step is typically to use the PREDICT() function to score the model against new data.
OPENJSON() is used for parsing JSON text, not for scoring machine learning models like ONNX models.
While ONNX models can be stored as binary data, simply loading the model into a binary variable doesn't implement or score it; it just holds the model's content.
Loading an ONNX model into a character variable is not the correct way to implement or score it, as ONNX models are typically binary files.
In Azure Synapse Analytics, the PREDICT() function is specifically designed to consume and score ONNX models directly within SQL, enabling real-time inference. This function takes the model and input data as arguments to generate predictions.
Concept tested: ONNX model scoring in Synapse SQL
Source: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/predict-with-synapse-sql
Topics
Community Discussion
No community discussion yet for this question.