Databricks Certified Data Analyst Associate — Question 21

A data analyst has been asked to configure an alert for a query that returns the income in the accounts_receivable table for a date range. The date range is configurable using a Date query parameter.
The Alert does not work.
Which of the following describes why the Alert does not work?

Answer options

• 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.

Correct answer: D

Explanation

The correct answer is D because alerts cannot be configured to work with queries that include query parameters. Options A and B are incorrect as alerts can work with table queries and date-based queries under certain conditions. Options C and E are also incorrect since the issue lies with the use of query parameters, not the type of parameters themselves.