Microsoft

DP-300 practice question 17

Administering Microsoft Azure SQL Solutions · free question 17 of 20

Question

You are designing an anomaly detection solution for streaming data from an Azure IoT hub. The solution must meet the following requirements: - Send the output to an Azure Synapse. - Identify spikes and dips in time series data. - Minimize development and configuration effort. Which should you include in the solution?
  • A. Azure SQL Database
  • B. Azure Databricks
  • C. Azure Stream Analytics Correct

Explanation

Azure Stream Analytics has built-in machine learning anomaly detection, and its AnomalyDetection_SpikeAndDip function finds spikes and dips directly in a job's query, so no model has to be built. It reads from IoT Hub and can write its results to Azure Synapse Analytics. Azure Databricks could do this too, but you would have to develop and run the detection code yourself, which fails the minimal-effort requirement. Azure SQL Database is not a stream processing engine for an IoT hub feed.

Need the theory? Learn it free in the DP-300 course on Godlike Academy

Practice the whole free set

Answer all 20 free DP-300 questions with instant feedback, or unlock all 373 questions with Learn and Exam modes.