DATABRICKS-DAA Question 61

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose C0

  - Correct answer : C — Set the alert's Data Value option to evaluate the first value of the `error_count` column, so only the top row of the sorted result set is compared against the threshold. A . Summing across all rows combines every hour's error count into one total, which still mixes in older rows instead of isolating just the most recent hour's value. B . Averaging across all rows blends the newest count together with every older row's count, so it does not isolate the most recent hour on its own. C . The first-value setting evaluates only the top row of the query result, which is the most recent hour given the sort order, matching exactly what the team wants. D . The notification template only formats the text of an already-fired alert message; a `LIMIT 1` placed there has no effect on which row the condition itself compares.