Snowflake Certification Path 2026: Which SnowPro Cert Should You Take? (FREE Guide)
Video
Which Snowflake role is the highest-privileged built-in role and the only one that can manage account-level parameters and billing-related settings by default?
Snowproadvancedadministrator Security Rbac Category
Question · Easy
Choose between SnowPro Core, Advanced and Specialty in 2026: current codes, prerequisites, fees, renewal and free independent study resources.
Blog
Which built-in role is intended to manage roles and grants without owning the underlying objects?
Which Snowflake construct grants privileges automatically to objects that will be created in the future?
Question · Medium
Tech Exam Prep Podcast
Listen on Spotify
Podcast
What is the maximum DATA_RETENTION_TIME_IN_DAYS for permanent tables on Standard Edition?
Snowproadvancedadministrator Account Governance Category
How long is Fail-safe retention for permanent tables in Snowflake?
Which warehouse property limits how aggressively additional clusters spin up under load on a multi-cluster warehouse?
Snowproadvancedadministrator Performance Tuning Category
Which warehouse type provides additional memory per node for memory-intensive workloads such as Snowpark ML training?
Which construct caps the credits a warehouse can consume in a billing interval?
Which Snowflake feature allows zero-storage-cost copies of databases or tables for development environments?
Snowproadvancedadministrator Disaster Recovery Category
Which view in ACCOUNT_USAGE shows a per-warehouse credit consumption history?
Which Snowflake role is required to manage organizations and add accounts in a multi-account hierarchy?
Which authentication method is recommended for service accounts that programmatically connect to Snowflake?
Which Snowflake mechanism enables sub-second streaming row insertion for low-latency pipelines?
Which approach is preferred for sharing a curated dataset with a third party that does not have a Snowflake account?
Snowproadvancedadministrator Data Sharing Category
Which Snowflake feature replicates databases across regions for disaster recovery and read scaling?
Which object groups multiple databases into a single failover unit for cross-region or cross-cloud failover?
Question · Hard
Which command lets a SYSADMIN-owned warehouse be transferred to a new owner role without dropping it?
Which Snowflake construct dynamically masks sensitive column values based on the current role at query time?
Which Snowflake feature lets you classify columns automatically (e.g., PII detection) based on content?
Which view tracks column-level access for queries, helping audit who read what?
Which Snowflake table type retains data only for the duration of the user session?
Which Snowflake table type is designed for low-latency OLTP workloads with primary keys and unique constraints enforced?
Which approach scales out concurrency for a warehouse facing many small simultaneous queries?
Which Snowflake feature speeds queries with high-cardinality equality lookups across many micro-partitions?
Which Snowflake feature accelerates ad-hoc analytical queries by sustaining high-throughput query execution beyond a single warehouse cluster?
Which approach helps identify the most expensive queries on an account over the last 30 days?
Which command displays the current role's privileges on a specific table?
Which Snowflake edition is required to use Customer-Managed Keys (Tri-Secret Secure)?
Which Snowflake construct restricts source IPs that can connect to an account?
Which connectivity option provides private connectivity between an AWS VPC and a Snowflake account on AWS?
Which is the recommended way to secure access for a partner engineer who needs read-only access to one schema for 30 days?
Which Snowflake feature is used to ingest files from cloud storage automatically as they appear?
Which Snowflake mechanism stores cost attribution by warehouse and time bucket for chargeback?
Which feature continuously refreshes a precomputed query result and keeps it consistent?
Which is the right way to enforce MFA across an account?
Which Snowflake construct provides a managed view over multiple shared databases for partner consumers in the Marketplace?
Which approach is correct when planning replication between regions for DR?
Which Snowflake feature lets you tag objects (databases, tables, columns) for governance reporting?
Which command suspends a warehouse manually without dropping it?
Which approach minimizes credit consumption for a small, intermittent reporting warehouse?
Which approach is recommended to roll out role design at scale?
Which view records the timestamps of user logins, authentication method, and source IP?
Which Snowflake feature lets you publish data products externally without replication, even cross-cloud?
Which command provides a JSON breakdown of a query plan for tuning?
Which scenario is most appropriate for a transient table?
Loading more…
