nerdexam
Microsoft

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.

Query and transform data

Question

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 first?

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)
  • B
    3% (1)
  • C
    5% (2)
  • D
    93% (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.

AScore Model1 by using OPENJSON().

OPENJSON() is used for parsing JSON text, not for scoring machine learning models like ONNX models.

BLoad Model1 into a binary variable.

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.

CLoad Model1 into a character variable.

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.

DScore Model1 by using PREDICT().Correct

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

#Azure Synapse Analytics#ONNX models#Model scoring#PREDICT function

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice