SnowPro Advanced: Data Engineer — Question 73

What considerations should a Data Engineer make when leveraging the table function TASK_HISTORY? (Choose two.)

Answer options

• A. Querying TASK_HISTORY will return only in progress or completed task executions.
• B. For the task of interest to be returned, it must have been triggered within the last 30 days.
• C. A user querying the table function must be the owner of the task or have elevated privileges.
• D. A RESULT_LIMIT parameter must be provided during execution because TASK_HISTORY is a table function.
• E. Any parameters used in the TASK_HISTORY table function will take precedent before SQL limiting functions.

Correct answer: B, C

Explanation

Option B is correct because TASK_HISTORY only retains data for tasks triggered in the last 30 days. Option C is also correct as it requires the user to either own the task or possess elevated privileges to access the query. The other options are incorrect because they either misstate how TASK_HISTORY operates or present requirements that are not necessary.