Designing and Implementing Enterprise-Scale Analytics Using Microsoft Azure and Power BI — Question 113

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?

Answer options

• A. PREDICT
• B. CAST
• C. GROUPING
• D. PIVOT

Correct answer: A

Explanation

The PREDICT function is specifically designed to assess probabilities and outcomes, making it suitable for scoring datasets to determine the likelihood of events such as engine failures. The other options do not serve this purpose: CAST is for type conversion, GROUPING is for identifying which columns are aggregated, and PIVOT is for transforming rows into columns.