Snowflake Certification Path 2026: Which SnowPro Cert Should You Take? (FREE Guide)
Video
Which Snowpark ML class provides one-hot encoding of categorical features as a Snowflake-native preprocessing step?
Snowproadvanceddatascientist Feature Engineering Category
Question · Easy
Overfitting: I memorized the practice test
Short
Choose between SnowPro Core, Advanced and Specialty in 2026: current codes, prerequisites, fees, renewal and free independent study resources.
Blog
A data scientist needs to generate 1024-dimensional embeddings for retrieval-augmented generation. Which Cortex LLM Function should be used?
Snowproadvanceddatascientist Model Development Category
Which Snowflake feature lets you reproduce a training dataset exactly as it existed two days ago without doubling storage cost?
Question · Medium
Tech Exam Prep Podcast
Listen on Spotify
Podcast
Which compute resource is required to run a containerized PyTorch training job with GPU acceleration inside Snowflake?
Snowproadvanceddatascientist Model Deployment Category
What does VECTOR_COSINE_SIMILARITY return between two embedding vectors?
Which Snowpark ML class trains a gradient-boosted classifier natively on Snowflake compute?
What is the primary purpose of the Snowpark ML Model Registry?
A team wants to convert a long passage into a concise abstract using Snowflake-managed LLMs. Which Cortex function should they call?
Which Cortex capability is purpose-built for retrieval-augmented generation with managed indexing of documents?
You need to convert a Snowflake table to a pandas DataFrame for local exploration. Which approach minimizes egress?
Snowproadvanceddatascientist Data Pipelining Category
Which evaluation metric is most appropriate for an imbalanced binary classification problem with 1% positive class?
Snowproadvanceddatascientist Data Science Concepts Category
Which Snowflake object lets you define declarative transformations that automatically refresh based on a target lag?
In the Feature Store, what does an entity represent?
Which Cortex function performs zero-shot text classification given a list of candidate labels?
Which warehouse type provides additional memory for Python workloads such as Snowpark ML training?
What is the primary risk of one-hot encoding a high-cardinality categorical feature with thousands of distinct values?
Which Cortex function converts a natural-language business question into Snowflake SQL given a semantic model?
Which technique prevents data leakage when computing rolling features for time-series ML training?
Question · Hard
After registering a model in the Snowpark ML Model Registry, what is the standard low-latency deployment option for SQL-callable scoring?
Which method should you call on a Snowpark DataFrame to materialize results back into a Snowflake table?
Which preprocessing transformer scales features to zero mean and unit variance using Snowpark ML?
Which Snowflake feature lets you write a Streamlit application that runs inside the Snowflake account with no external hosting?
Which Cortex function returns sentiment polarity for a text column?
What does Cortex Fine-tuning enable?
Which Snowflake object captures change data from a base table and is commonly chained with a Task for incremental ML pipelines?
Which technique converts a long ARRAY column of objects into one row per element for analysis?
Which Snowflake AI service extracts structured fields from unstructured PDFs and images?
Which technique is used to reduce overfitting of a deep neural network during training?
What is the maximum DATA_RETENTION_TIME_IN_DAYS for a permanent table on Enterprise Edition or higher?
Which Snowpark ML cluster algorithm is offered out of the box?
Which Snowflake SQL data type stores a fixed-length numeric vector for embedding similarity search?
Which scenario is the strongest fit for Cortex Search instead of a hand-rolled vector index?
What is a key advantage of vectorized UDFs compared with row-by-row Python UDFs?
Which is an appropriate use of Data Metric Functions (DMFs) in an ML pipeline?
Which technique helps detect concept drift in a deployed model over time?
What is the role of EVENT_TABLE in operating ML and AI workloads?
In Snowflake Notebooks, what is a key benefit of running cells against the active warehouse?
Which approach is best for handling categorical features with thousands of distinct values in tree-based models?
Which Snowflake function loads a JSON string into a VARIANT?
Which approach correctly splits a time-series dataset for model evaluation?
Which Snowpark ML class trains a logistic regression classifier?
What is a common cause of high variance in a model's predictions?
Which Cortex EMBED function returns a 768-dimensional embedding?
Which approach lets you keep training a Snowpark ML model across many warehouses or compute pools while preserving lineage?
Loading more…
