Implement Streams and Tasks ARA-C01 Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   Which of the following best describes the scheduling capabilities of a task in Snowflake?

   • ATasks can only run once and cannot be repeated
   • BTasks can be scheduled using a cron expression or a fixed interval
   • CTasks require a separate scheduler service to be configured
   • DTasks can only be triggered manually by a user
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   What is the primary purpose of a task in Snowflake?

   • ATo monitor the performance of running queries
   • BTo schedule SQL statements to run automatically on a defined schedule
   • CTo store and manage large volumes of semi-structured data
   • DTo provide a graphical interface for building data pipelines
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   What is a task DAG in Snowflake?

   • AA tree structure where each task has exactly one parent
   • BA directed acyclic graph of tasks where each task can have one or more predecessors
   • CA single task that runs multiple SQL statements
   • DA collection of tasks with no dependencies
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A team has a stream that is consumed by a task every hour. They notice that the stream is becoming stale and they want to monitor it to ensure it does not exceed a certain staleness threshold. What should they use to monitor stream staleness?

   • AThe TASK_HISTORY view in the ACCOUNT_USAGE schema.
   • BThe STREAM_STALENESS column in the STREAMS view in the ACCOUNT_USAGE schema.
   • CThe QUERY_HISTORY view in the ACCOUNT_USAGE schema.
   • DThe STREAM_HISTORY view in the ACCOUNT_USAGE schema.
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   How can you implement retry logic for a task in Snowflake?

   • ABy setting the RETRY_ATTEMPTS parameter in the CREATE TASK statement
   • BBy creating multiple tasks that run the same SQL statement
   • CBy configuring the task to automatically retry on failure using the ON_ERROR parameter
   • DBy using a stored procedure that catches exceptions and retries
   Reveal Solution Discussion Select an answer first