Answer-first summary for fast verification
Answer: Create an alert with a custom template, incorporating the built-in template variable `QUERY_RESULT_ROWS` to detail duplicate records.
Alerts are designed to notify users when specific conditions are met by a query's results. For custom notifications, especially those requiring detailed information like the count of duplicate records, a custom template is necessary. The `QUERY_RESULT_ROWS` variable is specifically designed to include details about the rows returned by the query, making it the correct choice for this scenario. Custom templates allow for the inclusion of dynamic data through built-in variables and support HTML formatting for better presentation of the alert details.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A data analyst wants to notify his team via email when the query loading aggregated sales data into the reporting table contains duplicate records, including the count of such duplicates. Which method should he use?
A
Configure an alert with a custom template, utilizing the built-in template variable QUERY_RESULT_COLS to include duplicate record details.
B
Set up an alert using the default template and manually insert the specific duplicate record information.
C
Use Python libraries to send a customized email notification when the alert is triggered.
D
Create an alert with a custom template, incorporating the built-in template variable QUERY_RESULT_ROWS to detail duplicate records.
E
Establish an alert with a custom template, using the built-in template variable QUERY_RESULT_VALUE to specify duplicate records.
No comments yet.