NiC IT Academy

SNOWFLAKE QUIZ – 08

By Mr.Chandra

Loading

01. What is the primary purpose of a task in Snowflake?

02. Which of the following statements is true about task trees in Snowflake?

03. What is the maximum depth of a task tree in Snowflake?

04. Which command activates a task?

05. What keyword creates dependency between tasks?

06. Snowflake Task Graph follows which architecture?

07. Which schedule runs every day at 7 AM UTC?

08. What happens when: ALLOW_OVERLAPPING_EXECUTION = FALSE and the previous execution is still running?

09. Which of the following is required for a task to run on a schedule?

10. How can you check the last few executions of a task in Snowflake?

11. A task repeatedly fails due to SQL errors. Eventually it enters which configuration state?

12. A company wants Snowflake to automatically allocate compute resources for scheduled tasks. Which type of task should they create?

13. While suspending a task graph, which task should be suspended first?

14. Which SQL command displays all tasks?

15. How do you execute multiple SQL statements within a task?

16. You created three dependent tasks. Which should be resumed first?

17. Which statement is TRUE about serverless tasks?

18. A developer creates a task but notices it never executes. What is the MOST likely reason?

19. Which statement about Snowflake Tasks is TRUE?

20. A company wants a child task to execute only after two parent tasks complete successfully. How can this be achieved?

Login with your email & password

Sign up with your email & password

Signup/Registration Form