nerdexam
Microsoft

DP-500 · Question #45

You have an Azure Synapse Analytics dataset that contains data about jet engine performance. You need to score the dataset to identify the likelihood of an engine failure. Which function should you…

The correct answer is C. PREDICT. The PREDICT function in Azure Synapse Analytics is used to score a dataset against a trained machine learning model, which is essential for identifying the likelihood of an event like engine failure.

Query and transform data

Question

You have an Azure Synapse Analytics dataset that contains data about jet engine performance. You need to score the dataset to identify the likelihood of an engine failure. Which function should you use in the query?

Options

  • APIVOT
  • BGROUPING
  • CPREDICT
  • DCAST

How the community answered

(56 responses)
  • A
    4% (2)
  • B
    2% (1)
  • C
    93% (52)
  • D
    2% (1)

Why each option

The PREDICT function in Azure Synapse Analytics is used to score a dataset against a trained machine learning model, which is essential for identifying the likelihood of an event like engine failure.

APIVOT

PIVOT is used for transforming rows into columns for aggregation, not for model scoring.

BGROUPING

GROUPING is used with GROUP BY clauses to distinguish between NULLs resulting from super-aggregate rows and regular NULLs, not for machine learning predictions.

CPREDICTCorrect

PREDICT is specifically designed for operationalizing machine learning models within SQL queries in Azure Synapse Analytics. It allows users to apply a previously trained model, such as one for identifying engine failure likelihood, to new data directly within a SQL script, returning predictions as part of the query result.

DCAST

CAST is used for converting an expression of one data type to another, which is unrelated to scoring a dataset with a machine learning model.

Concept tested: Azure Synapse Analytics PREDICT function for ML scoring

Source: https://learn.microsoft.com/en-us/sql/t-sql/queries/predict-transact-sql

Topics

#Azure Synapse Analytics#Machine Learning Prediction#SQL PREDICT Function

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice