Free Practice Questions for Snowflake Certification

- Select between Secure Data Sharing, Declarative Native Apps, and Snowflake Native Apps based on complexity, requirements, and cost - Plan schema separation - Data objects compared to logic objects - Identify Snowflake Native App Framework technical limitations and constraints - When to implement a Native App - When to create new App versions or to patch an existing version

- Apply least privilege principles in manifest privilege requests - Design security boundaries and access controls - When to use provider or consumer boundaries - Application compared to consumer data isolation - Cross-account security - Consumer approval workflows - Design application role hierarchies - Implement data protection strategies - Implement External access from Snowflake - APIs - External network access

- Create application package components. - Manifest file structure, sections, and version compatibility - Setup script - Manage database schema changes - Artifacts - Implement schema structure for version management - Versioned schemas compared to regular schemas - Object compatibility with versioned schemas - Implement application logic - Use stored procedures - Use external functions - Use User-Defined Functions (UDFs) - Use User-Defined Table Functions (UDTFs) - Use Streamlit - Use Snowpark Container Services - Configure compute pool settings - Implement service endpoint binding requirements - Implement container-based application architecture - Configure data bundling and in-app sharing strategies - Data packaging and sharing - Data inclusion decisions - Data sharing compared to private data boundaries - Manage package distribution settings - Configure distribution modes - Separate development and production packages - Establish external object references and dependencies

- Configure manifest file privilege specifications - Build application role structures - Secure cross-account reference patterns - Establish privilege-granting workflows - Establish App specifications and feature policies as consumer-side governance controls. - Code security requirements. - Grant global privileges. - EXECUTE TASK - EXECUTE MANAGED TASK - CREATE WAREHOUSE - MANAGE WAREHOUSES - CREATE DATABASE - Configure IMPORTED PRIVILEGES on databases. - Configure execution rights for Native App objects. - Owner's rights compared to restricted caller's rights. - EXECUTE AS OWNER - EXECUTE AS RESTRICTED CALLER - Consumer-side GRANT CALLER workflows - Limitations of restricted caller's rights - Intellectual property protection through execution rights

- Configure event tables and event sharing - Event definition and consumer approval workflows - required and optional events - Design event sharing permissions and governance - Configure application and required privileges - Manage Python environment configuration using environment.yml - Implement role-based access control in Streamlit UI - Utilize test mode for validation - Utilize development and debug modes for validation - Debug mode execution contexts - Implement permissions with SQL - Configure default log levels and trace levels in the manifest file

- Create new application versions. - Manage releases - Implement patch releases - Configure version upgrades - Manage version dependencies and rollback strategies - Establish consumer controlled maintenance policies. (Will not be tested on until it has been in Public Preview for 3 months)

- Configure private vs public listing settings - Navigate security scanning and approval processes - Code readability requirements - Source map requirements for minified code - Dependency vulnerability scanning - Meet requirements for app approval

- Configure subscription-based and usage-based billing models - Implement container billing and surcharge configuration - Set up billing event configuration - Set up custom billing events

- Create installation procedures - Ensure required privileges are available before installation - Set up privilege granting workflows during installation - Ensure provider account has necessary privileges to support installation - Handle cross-account installation considerations - Verify references to provider objects are accessible from the consumer account - Ensure proper connectivity between provider and consumer accounts - Support multiple application instances for each consumer account - Set up consumer-side event table configuration - Configure event sharing enablement - Handle multi-region event sharing considerations - Install and manage permissions - Create the application in a consumer account from Snowflake Marketplace compared to a package - Troubleshoot installation failures

- Configure version release management - Create and manage versions and patches - Set release directives (default and custom) - Configure release channels (QA, ALPHA, DEFAULT) - Configure release channels - Understand channel types and monetization implications - Manage version assignment workflows - Configure privileges for release management - Understand version assignment constraints - Configure auto-fulfillment settings - View metadata and usage metrics

- Manage upgrade policies when upgrades occur - Upgrade consumer side - Configure consumer-controlled maintenance policies - Set maintenance windows to prevent updates during specific time periods - Configure delayed upgrade schedules with start dates and times - Control automatic upgrade timing after release directives are issued - Uninstalled application behaviors

- Write idempotent code for upgrades - Manage database schema changes - Implement data integrity safeguards during upgrades - Plan versioning strategies and upgrade paths