DP-500 · Question #45
DP-500 Question #45: Real Exam Question with Answer & Explanation
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.
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
Explanation
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.
Common mistakes.
- A. PIVOT is used for transforming rows into columns for aggregation, not for model scoring.
- B. GROUPING is used with GROUP BY clauses to distinguish between NULLs resulting from super-aggregate rows and regular NULLs, not for machine learning predictions.
- D. 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
Reference. https://learn.microsoft.com/en-us/sql/t-sql/queries/predict-transact-sql
Topics
Community Discussion
No community discussion yet for this question.