Data Infrastructures with Snowflake Competency (Intermediate Level)

  • 25m
  • 25 questions
The Data Infrastructures with Snowflake Competency (Intermediate Level) benchmark measures your ability to recall and recognize how to utilize Time Travel and Fail-safe in Snowflake, install and configure SnowSQL, define and use variables, and utilize SnowSQL features. You will be evaluated on your ability to differentiate internal and external stages, load data using the classic Snowflake UI, and integrate Snowflake with Google Cloud Storage, Azure Blob Storage, and S3. You will also be evaluated on your skills in unloading data from Snowflake to different types of internal storage, querying staged files directly into Snowflake tables, and optimizing query performance. A learner who scores high on this benchmark demonstrates that they have the ability to work on Snowflake with minimal supervision.

Topics covered

  • configure GCP permissions
  • connect to Amazon S3 from Snowflake
  • connect to Amazon S3 using access keys
  • integrate Azure Blob Storage with Snowflake
  • load and query data
  • load data from stages
  • outline micro-partitioning in Snowflake
  • partition external tables
  • query data using the local disk cache
  • query external stages
  • query files in stages
  • query materialized views to observe performance benefits
  • recall how external stages work in Snowflake
  • recall how to integrate Snowflake with Azure
  • recall how to integrate Snowflake with Google Cloud Platform (GCP)
  • recall how user, named, and table stages work
  • recognize how to unload data in Snowflake
  • recognize internal and external stages in Snowflake
  • run queries on clustered date to query performance
  • set up a warehouse and table to load data
  • unload data to Amazon Simple Storage Service (S3) buckets
  • unload data to Azure Blob Storage containers
  • unload data to Google Cloud Storage buckets
  • use search optimization and recall its advantages
  • use table stages and error modes