Answer-first summary for fast verification
Answer: Queries that use query parameters cannot be used with Alerts.
According to the Databricks documentation and the community discussion consensus, queries that use query parameters cannot be used with Alerts. Alerts do not support user input or dynamic values - they only use the default values specified for query parameters in the SQL editor. When a query uses a Date query parameter, the alert will always use the same date range (the default value) regardless of the actual date, which causes the alert to not function as expected or not trigger at all. This makes option D the correct answer. Option A is incorrect because alerts do work with queries that access tables. Option B is incorrect because date-based queries can be used with alerts if they don't use query parameters. Options C and E are incorrect because alerts don't work with any type of query parameters, not just specific types.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A data analyst needs to set up an alert for a query that calculates the income from the accounts_receivable table over a configurable date range, which is specified using a Date query parameter. The alert is not functioning.
What is the reason the alert does not work?
A
Alerts don't work with queries that access tables.
B
Queries that return results based on dates cannot be used with Alerts.
C
The wrong query parameter is being used. Alerts only work with Date and Time query parameters.
D
Queries that use query parameters cannot be used with Alerts.
E
The wrong query parameter is being used. Alerts only work with dropdown list query parameters, not dates.
No comments yet.