Exam SnowPro Advanced Data Engineer topic 1 question 85 discussion

Actual exam question from Snowflake's SnowPro Advanced Data Engineer

Question #: 85
Topic #: 1

[All SnowPro Advanced Data Engineer Questions]

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

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.

Show Suggested Answer

Suggested Answer: BC 🗳️

by Kamiles at Aug. 19, 2025, 5:21 a.m.

Comments

Submit Cancel

e970753

18 hours, 15 minutes ago

Selected Answer: CE

when the TASK_HISTORY function is queried, its task name, time range, and result limit arguments are applied first followed by the WHERE and LIMIT clause. To view a task graph within this function, the invoking role requires at least one of the following privileges: OWNERSHIP privilege on the task (that is, the task owner). MONITOR or OPERATE privileges on the task. The global MONITOR EXECUTION privilege. The ACCOUNTADMIN role. https://docs.snowflake.com/en/sql-reference/functions/task_history

upvoted 1 times

...