The Snowflake 30-day free trial gives you $400 in credits to try Enterprise Edition features — a powerful learning environment, with some limits (for example, AI features are disabled by default). For SnowPro exam prep, running things on a live system in addition to reading the official docs and practice questions dramatically improves your pass rate. This article walks through everything from sign-up to the exam-prep activities that pay off the most.
| Item | Details |
|---|---|
| Duration | 30 days (counted from sign-up date) |
| Credits | $400 USD |
| Edition | Chosen at sign-up (Enterprise recommended for exam prep; some features are unavailable on trial accounts) |
| Cloud provider | Choose from AWS / Azure / GCP |
| Region | Selected at sign-up (Japan regions also available) |
| Credit card registration | Not required (no auto-billing) |
| AI features (Cortex) | Disabled by default; add a credit card to enable them (the trial continues) |
| Sample data | SNOWFLAKE_SAMPLE_DATA (TPC-H, TPC-DS, etc.) is pre-loaded |
Used carefully, $400 in credits is plenty for 30 days of exam prep. The biggest credit consumer is virtual warehouse runtime.
| Warehouse size | Credits per hour | Hours $400 buys you |
|---|---|---|
| X-Small | 1 credit | ~100 hours |
| Small | 2 credits | ~50 hours |
| Medium | 4 credits | ~25 hours |
| Large | 8 credits | ~12.5 hours |
| X-Large | 16 credits | ~6 hours |
X-Small is plenty for exam-prep learning. Use Large or above only temporarily for performance comparison experiments, then drop back to X-Small immediately.
Always configure auto-suspend on your warehouses. The default is 10 minutes, but for learning use you can save credits by shortening it to 1-2 minutes.
-- Set auto-suspend to 1 minute (60 seconds)
ALTER WAREHOUSE compute_wh
SET AUTO_SUSPEND = 60
AUTO_RESUME = TRUE;
-- Check the current setting
SHOW WAREHOUSES LIKE 'COMPUTE_WH';Get a hands-on feel for Snowflake's three-layer architecture (Storage / Compute / Cloud Services).
-- Storage Layer: create a table and store data
CREATE DATABASE exam_practice;
CREATE SCHEMA exam_practice.lab;
CREATE TABLE exam_practice.lab.sales (
sale_id INT AUTOINCREMENT,
product_name VARCHAR,
quantity INT,
sale_date DATE,
amount DECIMAL(10,2)
);
INSERT INTO exam_practice.lab.sales (product_name, quantity, sale_date, amount)
SELECT 'Product_' || seq4()::VARCHAR,
UNIFORM(1, 100, RANDOM()),
DATEADD(day, -UNIFORM(1, 365, RANDOM()), CURRENT_DATE()),
UNIFORM(100, 10000, RANDOM()) / 100.0
FROM TABLE(GENERATOR(ROWCOUNT => 10000));
-- Compute Layer: run the query on a different warehouse to see the isolation
CREATE WAREHOUSE analytics_wh WITH WAREHOUSE_SIZE = 'XSMALL';
USE WAREHOUSE analytics_wh;
SELECT product_name, SUM(amount) FROM exam_practice.lab.sales GROUP BY 1;-- Time Travel: delete data by mistake, then restore it
DELETE FROM exam_practice.lab.sales WHERE sale_date < '2025-06-01';
-- Look at the data before the delete (Time Travel with the AT clause)
SELECT COUNT(*) FROM exam_practice.lab.sales
AT(OFFSET => -60*5); -- the state 5 minutes ago
-- Restore the table with UNDROP
DROP TABLE exam_practice.lab.sales;
UNDROP TABLE exam_practice.lab.sales;
-- Zero-Copy Clone: duplicate a table with no storage cost
CREATE TABLE exam_practice.lab.sales_clone
CLONE exam_practice.lab.sales;
-- The clone is an independent object (changes do not affect the source)
UPDATE exam_practice.lab.sales_clone SET amount = 0 WHERE sale_id = 1;-- Practise window functions on the sample data
SELECT
o_orderpriority,
o_totalprice,
ROW_NUMBER() OVER (PARTITION BY o_orderpriority ORDER BY o_totalprice DESC) AS rn,
RANK() OVER (PARTITION BY o_orderpriority ORDER BY o_totalprice DESC) AS rnk,
SUM(o_totalprice) OVER (
PARTITION BY o_orderpriority
ORDER BY o_orderdate
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
) AS running_total
FROM SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.ORDERS
QUALIFY rn <= 5;AI features are disabled by default on trial accounts, so add a credit card to the account before this exercise (adding a card doesn't upgrade the trial to a paid account or end the trial period).
-- AI_COMPLETE: text generation
SELECT AI_COMPLETE(
'mistral-large2',
'Briefly explain what a Snowflake micro-partition is'
) AS response;
-- AI_SENTIMENT: sentiment analysis (returns positive, negative, neutral, and so on)
SELECT
comment_text,
AI_SENTIMENT(comment_text) AS sentiment
FROM (
SELECT 'This service is excellent. I use it every day.' AS comment_text
UNION ALL
SELECT 'The response is far too slow to be usable.' AS comment_text
);-- Role-based access control (RBAC) in practice
CREATE ROLE analyst_role;
CREATE ROLE engineer_role;
GRANT USAGE ON DATABASE exam_practice TO ROLE analyst_role;
GRANT USAGE ON SCHEMA exam_practice.lab TO ROLE analyst_role;
GRANT SELECT ON ALL TABLES IN SCHEMA exam_practice.lab TO ROLE analyst_role;
GRANT ALL ON DATABASE exam_practice TO ROLE engineer_role;
GRANT ROLE analyst_role TO ROLE engineer_role; -- role hierarchy
-- Dynamic Data Masking(Enterprise Edition)
CREATE MASKING POLICY email_mask AS (val STRING)
RETURNS STRING ->
CASE
WHEN CURRENT_ROLE() IN ('ACCOUNTADMIN', 'ENGINEER_ROLE')
THEN val
ELSE '***@***.com'
END;Getting comfortable with the Snowsight web UI also helps on the exam. The Data Analyst exam (retiring December 1, 2026) in particular tests Snowsight Dashboard knowledge.
-- Configure a Resource Monitor (credit-limit alerts)
CREATE RESOURCE MONITOR trial_monitor
WITH CREDIT_QUOTA = 50
FREQUENCY = DAILY
START_TIMESTAMP = CURRENT_TIMESTAMP
TRIGGERS
ON 80 PERCENT DO NOTIFY
ON 100 PERCENT DO SUSPEND;
ALTER WAREHOUSE compute_wh SET RESOURCE_MONITOR = trial_monitor;Snowflake Trial
Question 1
Which statement about a Snowflake free trial account is correct?
Correct answer: A
With the Snowflake free trial, you choose an edition (such as Enterprise Edition) at sign-up and use it for 30 days with $400 in credits (the trial ends early if you use up the credits). No credit card is required at sign-up and no automatic billing occurs. AI features, however, are disabled by default and require adding a credit card. Enterprise Edition also includes advanced features such as Time Travel up to 90 days, Dynamic Data Masking, and Row Access Policy.
Will I be charged automatically if I use up the free trial credits?
Once you exhaust the $400 in credits or 30 days have passed, the trial account is automatically suspended. Adding a credit card does not by itself upgrade the account to a paid account or end the trial period; billing starts only when you upgrade to a paid account yourself. If you convert your account to a paid plan after the trial ends, you can carry over all of your existing data and objects.
Can I use Cortex AI (LLM Functions) during the free trial?
Yes, but not by default. AI features are disabled by default on self-service trial accounts; to enable them, add a credit card to the account. Adding a credit card doesn't upgrade the trial to a paid account or end the trial period. Once enabled, you can use Cortex AI Functions such as AI_COMPLETE, AI_SUMMARIZE, AI_SENTIMENT, and AI_TRANSLATE (the official docs treat the older SNOWFLAKE.CORTEX functions such as COMPLETE as legacy and provide a guide for migrating to the AI_ functions). AI features also consume your trial credits, so heavy invocation burns through them quickly. Exam-prep-level usage (a few dozen calls) fits comfortably within the available balance.
Which features are most effective for exam prep during the trial?
The single most effective activity is SQL practice with the SAMPLE_DATA schema (SNOWFLAKE_SAMPLE_DATA.TPCH_SF1). It lets you experience the architecture, window functions, and Time Travel/Clone operations that cover most of the SnowPro Core exam on a live system. The next most important area is experimenting with warehouse settings (size changes, auto-suspend, multi-cluster configuration), which deepens your understanding of the performance domain.
Practice with certification-focused question sets
Try free questionsNicheeLab Editorial Team
NicheeLab editorial team focused on data engineering and cloud certification learning. Content is structured around practical study needs and official exam domains.
Snowflake Certifications: All 11 Exams Explained (2026)
Every SnowPro certification on Snowflake's official list — C...
Snowflake Exam Difficulty Ranking: All 11 Certs Compared (2026)
All 11 SnowPro exams compared by difficulty in a ranking and...
Snowflake Study Guide: Fastest Pass Route by Exam (2026)
How to pass SnowPro certifications efficiently — official ma...
SnowPro Core (COF-C03): Complete Exam Guide (2026)
Pass the SnowPro Core exam — five domains, scope, sample que...
SnowPro Associate Platform (SOL-C01): Current Status & What to Take Next (2026)
As of October 2026, SnowPro Associate: Platform (SOL-C01) is...