Final Exam: Continuous Data Pipelines in Snowflake

WHAT YOU WILL LEARN

• 

  Identify how to use and configure dynamic tables in snowflake
  

  create a dynamic table, configure the refresh_mode, and initialize properties
  

  create a dynamic table that depends on another dynamic table and ensure their refresh modes are compatible
  

  configure a dynamic table to only refresh on demand
  

  compare stream types and identify the contents of a standard stream during insert, update, and delete operations
  

  use variants of the merge into command to combine stream contents with the target table for inserts and updates
  

  create a dynamic table, configure the refresh_mode, and initialize properties
  

  create an append-only stream and analyze how it deals with insert, update, and delete operations on the base table
  

  outline repeatable read isolations in streams
  

  analyze the behavior of streams from within transactions
• 

  implement streams on views and analyze if they are working
  

  build and execute a scheduled serverless task
  

  create a user-managed scheduled task using a cron expression
  

  implement a task graph with one root node and two child nodes that each depend upon the root
  

  design and partially implement a task graph with two root nodes and a single child node that depends upon both root nodes
  

  use dummy root nodes to circumvent snowflake's restriction on multiple root nodes in a task graph
  

  create and use a triggered task that executes whenever a standard stream has data that can be consumed
  

  construct an architecture that utilizes streams, tasks, stages, and dynamic tables to feed into a dynamic dashboard
  

  extend a data pipeline by adding a triggered task to consume stream data and a dynamic table to compute base table analytical queries
  

  create a dashboard to consume data from different tables and dynamic tables in snowflake