Snowflake Certification Path 2026: Which SnowPro Cert Should You Take? (FREE Guide)
Video
Which Snowflake function converts a JSON string into a queryable VARIANT?
Snowproadvanceddataanalyst Data Analysis Category
Question · Easy
Wedding seating, as a LEFT JOIN
Short
Choose between SnowPro Core, Advanced and Specialty in 2026: current codes, prerequisites, fees, renewal and free independent study resources.
Blog
Which window function returns the value of the previous row within a partition?
Which Snowflake construct lets you express a recursive query for a hierarchy (e.g., manager-employee)?
Question · Medium
Tech Exam Prep Podcast
Listen on Spotify
Podcast
Which Snowflake function pivots an ARRAY column into one row per element?
Which Snowflake feature renders an interactive chart inside a worksheet without external BI tools?
Snowproadvanceddataanalyst Data Presentation Category
Which command loads a Parquet file from an external stage into a Snowflake table?
Snowproadvanceddataanalyst Data Ingestion Category
Which Snowflake feature continuously refreshes a table from a source query with a target lag?
Snowproadvanceddataanalyst Data Transformation Category
Which window frame returns a 7-day rolling sum partitioned by store?
Which Snowflake function extracts a numeric value from a JSON path in a VARIANT column?
Which Cortex feature converts a natural-language question into Snowflake SQL given a semantic model?
Which BI tool integration uses Snowflake's native Snowflake driver (DSN-less) to connect with OAuth?
Which file format is most appropriate for analytics workloads needing column pruning and predicate pushdown?
Which Snowflake construct lets you write a small interactive data app that runs entirely inside Snowflake?
Which is true about result caching for Snowsight dashboards?
Which Snowflake feature reads cloud-storage files as if they were tables, without ingesting?
Which Snowflake table type enables interoperability with Spark, Trino, and other Iceberg-compatible engines?
Which command merges new rows from a staging table into a target dimension, updating existing keys and inserting new ones?
Which Snowsight feature lets users subscribe to query result thresholds and get notified?
Which window function ranks rows with no gaps between equal values?
Which approach is best for analyzing nested JSON event logs at query time?
Which Snowflake function returns the cumulative count of rows up to and including the current row in an ordered partition?
Which Snowsight feature lets you organize multiple charts and queries into a shareable single-page view?
Which Snowflake function returns the ratio of each row's value to the SUM within its partition?
Which is true about Cortex Analyst?
Which join type returns one row per matching pair plus rows from the left side that have no match?
Which Snowflake function returns each unique key in an OBJECT (VARIANT) value?
Which Snowflake feature accelerates point lookups on highly selective predicates by maintaining a per-column data structure?
Which approach removes duplicates while keeping only the most recent record per key?
Question · Hard
Which is true about Snowflake INFORMATION_SCHEMA vs ACCOUNT_USAGE?
Which file format option lets COPY INTO infer columns automatically when loading Parquet?
Which Snowflake function adds a column of natural numbers to result rows in deterministic order within a partition?
Which Snowflake function returns the sample median of a numeric column?
Which Snowflake construct allows you to attach data quality metrics to columns and tables?
Which Snowsight feature visualizes column lineage between objects?
Which Snowflake feature is best when you need to ingest streaming application events for near-real-time dashboards?
Which Snowflake function converts a UTC timestamp to a specified time zone for reporting?
Which JOIN style efficiently flattens an array column inline into rows for analysis?
Which Snowflake feature returns the percent of total revenue per region in a single SQL query?
Which Snowflake feature can pre-compute and store a heavy aggregation that auto-refreshes incrementally?
Which approach is best for handling slowly changing dimensions (SCD Type 2) in Snowflake?
Which Snowflake feature enables multi-stage analytic queries to share intermediate results within a single statement?
Which Snowflake function returns the number of rows from the start of an ordered partition through the current row?
Which Snowflake feature surfaces a unified governance view across catalog, lineage, quality, privacy, and compliance?
Which Snowflake construct accelerates highly repetitive analyst queries while saving warehouse credits?
Loading more…
