Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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.
QUERY_RESULT_COLS
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.
QUERY_RESULT_ROWS
E
Establish an alert with a custom template, using the built-in template variable QUERY_RESULT_VALUE to specify duplicate records.
QUERY_RESULT_VALUE
