Free Practice Questions for Snowflake Certification

Construct distributed feature engineering pipelines.

• Use ML preprocessing functions (e.g., MinMaxScaler, OneHotEncoder)
• Transform large data sets within Snowflake
• Load and transform data with DataFrames
• Analyze use cases for SQL vs Snowpark
• Select appropriate data storage methods (stages, tables, data shares)

Implement Snowflake Feature Store architecture and management.

• Define and configure Feature Store entities
• Create feature views
• Implement Feature Store architecture for centralized management
• Register ML features as centralized metadata objects
• Configure external feature views
• Track versions of features using version control
• Use Snowpark dataframe to build a feature store
• Identify dynamic tables in the Feature Store
• Manage data sets for training, validation, and inference

Ensure temporal integrity and feature consistency.

• Design lookups using Snowflake Feature Store views
• Generate training sets preventing temporal data leakage
• Verify consistency between offline training and online feature retrieval
• Ensure Dev/Prod feature consistency

Configure automated ingestion and data quality.

• Snowflake Lineage visualization and querying
• Configure streaming data ingestion for near real-time feature generation
• Implement Snowflake Data Quality Monitoring
• Configure feature validation rules
• Monitor feature freshness, data quality, schema changes, and drift

Operationalize features as first-class data assets.

• Package and version feature transformations (Snowpark, SQL, dynamic tables)
• Scale batch and near-real-time feature computation
• Deploy and promote feature pipelines (tasks, dynamic table refresh policies)

Manage infrastructure for ML.

• Deploy custom model runtime environments (containerized images)
• Operate ML Jobs
• Configure and compare ML distributed APIs (warehouse vs container)
• Configure compute pools for ML workloads and Snowpark Container Services
• Optimize resource allocation between warehouses and Container Runtime

Utilize Snowflake Workspaces.

• Train models within Snowflake Notebooks in Workspaces
• Leverage distributed data processing capabilities
• Analyze use cases for Workspaces vs stored procedures, SQL, or Python files
• Use open-source packages to build and evaluate models
• Use DataConnector with open source packages for data ingestion
• Identify default GPU allocation constraints for notebook instances

Track experiments and metadata.

• Structure nested experiments to log performance metrics, hyperparameters, and artifacts (Snowpark ML metadata)
• Execute hyperparameter optimization (HPO) workflows
• Implement CustomModel API for integrating external models
• Monitor comprehensive experiment tracking
• Associate models with specific dataset versions for lineage and reproducibility

Operate the Snowflake Model Registry.

• Register model artifacts, custom models, versions, and aliases
• Archive and deprecate model versions
• Execute model rollback procedures
• Assign model aliases (e.g., @prod)
• Extract and manage model artifacts (pickle files, serialized components)
• Validate model artifact integrity
• Deploy registered models across different environments and accounts
• Configure model promotion workflows
• Validate model compatibility across environment configurations

Implement inference deployment patterns.

• Deploy models to managed HTTPS endpoints in Snowpark Container Services
• Execute batch inference pipelines using registry-backed execution
• Deploy batch inference as service functions
• Run large batch workloads on Snowpark Container Services (job-based)
• Process unstructured data and multimodal models
• Track metrics for Real-time Inference via REST API endpoints

Execute platform migrations.

• Migrate existing models from third-party platforms into Snowflake
• Identify Snowflake-native alternatives to external MLOps tools and workflows

Orchestrate end-to-end ML workflows.

• Develop automated pipelines (data validation, training, deployment)
• Integrate ML capabilities with developer tools (Snowflake CLI, SnowSQL, SDKs)

Configure CI/CD and version control.

• Configure Git integration in Snowflake
• Automate ML code deployment
• Leverage Snowflake CLI for automation
• Deploy ML assets using Snowflake-native promotion workflows
• Configure Snowflake object dependencies for ML pipeline deployment

Implement retraining and troubleshooting.

• Define automated retraining policies (data drift alerts, performance degradation)
• Troubleshoot pipeline failures (warehouse capacity, container scalability, data dependency)

Enforce Snowflake security policies.

• Ensure appropriate privileges for Snowflake ML components (Feature Store, Model Registry, compute pools)
• Apply Snowflake Dynamic Data Masking and row-level Security
• Establish data governance policies for ML model compliance

Monitor model health and compliance.

• Track data drift and statistical anomalies (Snowflake's integrated monitoring and alerting)
• Audit all model interactions and inference calls for lineage
• Configure alerts for ML data governance violations
• Configure automated model performance degradation alerts
• Implement model accuracy and drift threshold monitoring
• Monitor model serving performance metrics (latency, throughput, availability)

Manage ML cost attribution and resource optimization.

• Tune warehouse optimization strategies and compute pool sizing
• Track costs for ML features with granular attribution
• Track costs of Snowpark Container Services compute pool and optimize it