
Ultimate access to all questions.
You are working on a data cleansing project using Azure Stream Analytics. You have a stream of sensor data that includes temperature readings from multiple sensors. Some of the readings are incorrect or corrupted, and you need to filter out these invalid data points. Which of the following approaches would be most effective for cleansing the data in real-time?
A
Use a batch processing approach and store the data in a temporary storage before cleansing.
B
Implement a custom deserialization logic to handle the corrupted data points.
C
Use the built-in 'IS NULL' condition in the SELECT statement to filter out null or missing values.
D
Leverage the built-in 'WHERE' clause to apply a range filter based on the expected temperature values.