Free practice · No sign-up required
15 questions with answer explanations. Choose an answer below to begin.
What is the primary purpose of a virtual warehouse in Snowflake?
Understand core compute concepts in Snowflake
0/15 answered · Bookmark questions to review later. Focus the practice area to use keys 1–9 and Enter.
Learn by doing
Use official documentation and hands-on labs to work through topics you missed.
Prefer to read at your own pace? Work through each question below, then open its answer to check your reasoning. You can link directly to a question or print this reference.
What is the primary purpose of a virtual warehouse in Snowflake?
To provide compute resources for query execution
To store backup snapshots of databases
To manage user authentication
To define secure network access rules
Correct answer
To provide compute resources for query execution
A virtual warehouse is a compute resource that scales independently to execute SQL queries. It does not store data or handle authentication.
Which statement best describes Snowflake's data storage architecture?
Data is stored in columnar format and managed automatically by Snowflake
Data must be pre-partitioned before loading
Data is stored in row format for optimal query performance
Users manually manage storage clusters
Correct answer
Data is stored in columnar format and managed automatically by Snowflake
Snowflake stores data in a columnar, compressed format and handles partitioning and optimization internally. Users do not manage storage clusters directly.
What does Time Travel in Snowflake enable you to do?
Query historical data as it existed at a previous point in time
Reduce storage costs by archiving old data
Accelerate data ingestion from external sources
Automatically back up data to external cloud storage
Correct answer
Query historical data as it existed at a previous point in time
Time Travel allows you to access past versions of data within a defined retention period, useful for recovery and auditing.
Which feature provides automatic failover and redundancy for critical Snowflake accounts?
Account Replication
Data Sharing
Secure Data Masking
Query Acceleration
Correct answer
Account Replication
Account Replication supports creating read-only replicas of an account for disaster recovery and high availability.
How are stages used in Snowflake?
To define external locations for loading and unloading data
To manage SQL query execution plans
To configure network firewall rules
To store metadata about user sessions
Correct answer
To define external locations for loading and unloading data
Stages are objects that represent locations in internal or external storage where data files are kept for loading into tables.
What is the effect of clustering keys on a Snowflake table?
They improve query performance by organizing data micro-partitions
They encrypt sensitive columns in the table
They automatically partition data by date
They restrict access to specific users
Correct answer
They encrypt sensitive columns in the table
Clustering keys define the preferred ordering of data to help with pruning during queries, improving performance.
Which statement about Snowflake data sharing is true?
It allows real-time access to data without copying between accounts
It requires exporting data to external stages first
It only works within the same virtual warehouse
It permanently transfers ownership of data objects
Correct answer
It allows real-time access to data without copying between accounts
Data sharing enables secure, live access to data across Snowflake accounts without duplicating or transferring data.
What does the zero-copy cloning feature provide?
Instant creation of a copy of a database or table with minimal storage overhead
Automatic encryption of cloned objects
Replication of data to on-premises systems
Conversion of row-based data to columnar format
Correct answer
Instant creation of a copy of a database or table with minimal storage overhead
Zero-copy cloning creates metadata copies of objects almost instantly, without duplicating the underlying storage.
Which task can be automated using Snowflake tasks?
Executing SQL statements on a schedule
Configuring network security policies
Managing external cloud credentials
Designing table schemas visually
Correct answer
Executing SQL statements on a schedule
Snowflake tasks allow you to schedule and automate SQL operations, such as data transformations or report generation.
What is the purpose of a Snowflake role?
To define a collection of permissions granted to users
To store large volumes of semi-structured data
To manage external data connections
To optimize query execution plans
Correct answer
To define a collection of permissions granted to users
Roles in Snowflake are used to grant and manage access privileges for users and other roles.
Which data type is best suited for storing semi-structured data in Snowflake?
VARIANT
ARRAY
OBJECT
MAP
Correct answer
VARIANT
The VARIANT data type can store JSON, Avro, ORC, Parquet, and other semi-structured data natively.
What does the Snowflake Query Profile provide?
A visual breakdown of query execution steps and resource usage
A summary of user login history
A list of all external stages in the account
A report on data sharing access logs
Correct answer
A visual breakdown of query execution steps and resource usage
The Query Profile shows detailed execution information, including timing, stages, and data processed for each query.
Which practice helps optimize query performance in Snowflake?
Using appropriate clustering keys and filtering early in the query
Storing all data in a single large table
Disabling result caching for all queries
Avoiding the use of virtual warehouses
Correct answer
Using appropriate clustering keys and filtering early in the query
Good performance practices include clustering data appropriately and applying filters as early as possible in the query.
What is the function of a Snowflake parameter in session management?
To customize session behavior such as date format or time zone
To define physical storage locations
To control network bandwidth usage
To manage external function integrations
Correct answer
To customize session behavior such as date format or time zone
Session parameters control aspects like date formats, time zones, and error handling for the duration of a session.
Which statement about Snowflake scalability is correct?
Compute and storage scale independently, allowing flexible resource management
Scaling requires manual data re-partitioning
Storage scales automatically, but compute must be fixed
Compute scaling affects data retention policies
Correct answer
Compute and storage scale independently, allowing flexible resource management
Snowflake's architecture separates compute and storage, enabling independent scaling of each resource.
Recall the answer before opening each card.
To provide compute resources for executing SQL queries; it scales independently from storage.
In a columnar, compressed format with automatic partitioning and optimization; users do not manage storage clusters.
Query historical data as it existed at a previous point in time within a defined retention period for recovery or auditing.
Account Replication, which creates read-only replicas for disaster recovery.
To define internal or external locations for loading and unloading data files into/from Snowflake tables.
They define the preferred ordering of data to improve query performance by enabling better pruning.
It allows real-time, live access to data across accounts without copying or transferring the data.
Instant creation of a metadata copy of a database or table with minimal storage overhead; no data duplication initially.
Executing SQL statements on a schedule, such as data transformations or report generation.
To define a collection of permissions that can be granted to users for access control.
VARIANT, which natively stores JSON, Avro, ORC, Parquet, etc.
A visual breakdown of query execution steps, timing, and resource usage for performance analysis.
Using appropriate clustering keys and applying filters early in the query to reduce data scanned.
To customize session behavior such as date format, time zone, or error handling for the duration of a session.
Independently; compute (virtual warehouses) and storage scale separately, allowing flexible resource management.
The clone initially shares the underlying storage with the source; storage grows only when data changes.
Internal stages are managed by Snowflake and store files internally; external stages refer to locations in cloud storage (e.g., S3, Azure Blob).
By creating roles and granting privileges to them, then assigning roles to users.
To provide compute resources (CPU, memory) for query execution and data manipulation tasks.
Via Account Replication and failover features, automatically replicating data across regions or accounts.
Read the prompt, commit to an answer, then flip the card. Move through the deck at your own pace and repeat any topic that does not come back quickly.
Card 1 of 20
1 reviewed this session
Connect the concepts
Open a branch to connect a topic with its practice questions and explanations. Use the map to choose your next review topic.
This is an analysis of the practice bank, not a claim about the vendor's live exam blueprint. Use it to identify the knowledge, judgment, and recall patterns exercised here, then verify your coverage against the current official exam guide.
The practice bank emphasizes Snowflake's unique architecture where compute (virtual warehouses) and storage are decoupled. A virtual warehouse provides elastic compute resources for query execution, not data storage. Data is stored in a compressed columnar format with automatic management. Understanding this separation is fundamental because it allows independent scaling and cost optimization. Questions highlight that warehouses can be resized or suspended without affecting stored data. The scalability and elasticity of this model are key differentiators.
This section covers features that protect data and enable recovery. Time Travel allows querying historical data within a retention period (default 1 day, up to 90 days with Snowflake Enterprise). Account Replication creates read-only replicas for disaster recovery and failover. Zero-copy cloning provides instant metadata copies without duplicating storage initially, enabling safe testing and development. These features are critical for data governance, auditing, and business continuity.
Stages are used to define locations for loading and unloading data, supporting both internal (Snowflake-managed) and external (cloud storage) options. Data sharing allows real-time, live access to data across Snowflake accounts without data movement, enabling collaboration and data monetization. The practice bank tests understanding of stages as temporary data landing zones and sharing as a secure, no-copy method for distributing data.
The practice bank covers techniques to optimize query performance and automate workflows. Clustering keys define data ordering to improve pruning. The Query Profile visualizes execution details for troubleshooting. Session parameters customize query behavior. Roles centralize access control. Tasks schedule SQL execution for automation. These tools enable efficient, secure, and managed data operations.
Study workflow
Sign in to Snowflake. Use CREATE WAREHOUSE to define compute resources (size, scaling policy). Sizing affects performance and cost. Start with an X-Small warehouse for development. Use ALTER WAREHOUSE to resize or suspend when idle to save credits.
Execute a query on historical data by using AT or BEFORE clauses (e.g., SELECT * FROM table AT(TIMESTAMP => '...')). To restore a dropped table, use UNDROP TABLE. Time Travel retention depends on edition; check with SHOW PARAMETERS.
First, define a stage object: CREATE OR REPLACE STAGE my_stage URL='s3://bucket/path/' CREDENTIALS=(...). Use LIST @my_stage; to see files. Then load data into a table with COPY INTO table FROM @my_stage FILE_FORMAT = (TYPE = CSV). Validate with SELECT.
Identify columns used in filters (e.g., date, region). Run ALTER TABLE table_name CLUSTER BY (column1, column2). Monitor clustering depth with SYSTEM$CLUSTERING_INFORMATION. Automatic clustering may incur credits. Test query performance before and after.
Create a task with CREATE TASK refresh_task WAREHOUSE = my_wh SCHEDULE = '5 MINUTE' AS INSERT INTO summary SELECT ... FROM source. Start the task with ALTER TASK refresh_task RESUME. Use task graph for dependencies. Monitor with SHOW TASKS.
FAQ
Clear boundaries on what the bank covers, how to use it, and where official vendor information still matters.
Zero-copy cloning creates a writable copy of data that shares storage until changes are made, ideal for testing. Data sharing provides live, read-only access across accounts without copying data, suitable for collaboration.
Snowflake separates compute from storage. Storage is all shared across users and is automatically managed in columnar format. Compute (virtual warehouses) is elastic and independent. This allows scaling compute without affecting storage and vice versa.
VARIANT allows storing and querying semi-structured data (JSON, Avro, etc.) natively without schema definition. It supports key-value traversal and semistructured functions, enabling flexible data ingestion and analysis.
Use the Query Profile in the web interface or via GET_QUERY_OPERATOR_STATS. It visualizes execution steps, time spent, and data scanned. Also check query history with INFORMATION_SCHEMA.QUERY_HISTORY for duration, credits, and bytes scanned.
A virtual warehouse provides CPU, memory, and compute resources to execute queries. It caches table data for faster access. Multi-cluster warehouses can scale out for high concurrency. Warehouses are not persistent; they can be suspended when not in use.
Browse another free bank or use the study strategy guide to turn your misses into spaced review.
