SKILL BENCHMARK

Data Infrastructures with Snowflake Literacy (Beginner Level)

  • 16m
  • 16 questions
Explore all Skills Benchmarks
The Data Infrastructures with Snowflake Literacy (Beginner Level) benchmark measures your ability to recall, recognize, and list features and use cases of Snowflake and differentiate the Snowflake editions. You will be evaluated on your skills in utilizing virtual warehouses and databases to separate data and compute, identify, and view database objects in Snowsight. You will also be evaluated on your ability to run queries using Snowsight worksheets, build dashboards in Snowsight, and list use cases and attributes of permanent, temporary, and transient tables. A learner who scores high on this benchmark demonstrates that they have the knowledge required to start learning about and working on Snowflake with supervision.

Topics covered

  • add visualizations to dashboards
  • create a simple warehouse
  • create databases and warehouses from Snowsight
  • differentiate permanent, temporary, and transient tables
  • execute queries and view the output
  • move tables across schemas
  • outline Snowflake’s architecture
  • outline the structure in which objects are organized
  • read data into Snowflake
  • recall how partitioning and clustering work
  • recall how virtual warehouses work
  • recognize the technology of the Snowflake data platform
  • use database and account objects in Snowflake
  • use daterange and datebucket to interactively query dates
  • use permanent and temporary tables
  • use the Snowsight UI