Snowflake Quiz — 25 Questions
1. What is Snowflake primarily designed for?
A. Transactional OLTP database
B. Cloud-native data warehouse
C. NoSQL document store
D. Blockchain ledger
2. In Snowflake, data is stored in:
A. Each virtual warehouse
B. Centralized cloud storage layer
C. Local on-prem servers
D. Individual compute nodes
3. What is a virtual warehouse in Snowflake?
A. A logical storage container
B. A compute cluster for executing queries
C. A backup of a database
D. A table schema
4. What does “micro-partitioning” refer to?
A. Splitting warehouses into small nodes
B. Automatically partitioning tables into 50–500 MB blocks
C. Dividing queries into micro-tasks
D. Partitioning stage files manually
5. Which of these is TRUE about Time Travel?
A. Allows rollback of dropped tables within a retention period
B. Only works for external stages
C. Can restore data older than 1 year by default
D. Automatically deletes table backups
6. Fail-safe in Snowflake is:
A. Real-time backup for 7 days
B. Same as Time Travel
C. Automatic warehouse scaling feature
D. An ETL pipeline
7. Zero-copy cloning allows:
A. Copying data without duplicating storage
B. Moving warehouses between regions
C. Cloning warehouses
D. Creating a backup in S3
8. How do Snowflake tasks run?
A. Based on virtual warehouse CPU usage
B. After predecessor tasks complete successfully
C. Immediately after table creation
D. Only manually
9. What does a Snowflake stream do?
A. Manages warehouse auto-scaling
B. Tracks changes (CDC) in a table
C. Moves data between regions
D. Streams dashboards to BI tools
10. How can you ingest streaming data into Snowflake continuously?
A. CREATE PIPE + Snowpipe
B. CREATE STREAM
C. CREATE TASK
D. ALTER TABLE
11. How do you query JSON data in Snowflake?
A. Only by converting JSON to CSV
B. Using VARIANT column type + dot notation
C. Using JSON indexes
D. Using a separate NoSQL database
12. Which is TRUE about Snowflake result caching?
A. Only caches table definitions
B. Speeds up repeated queries if underlying data hasn’t changed
C. Requires manual enabling
D. Only works on streams
13. What is the main advantage of separating compute and storage in Snowflake?
A. Faster table creation
B. Independent scaling of compute without affecting storage cost
C. Multi-region replication
D. Reduces table size
14. How can you recover a dropped table in Snowflake?
A. RESTORE TABLE command
B. UNDROP TABLE command
C. CREATE TABLE AS SELECT *
D. Using Fail-safe only
15. What is the maximum retention period for Time Travel (standard edition)?
A. 1 day
B. 7 days
C. 90 days
D. Unlimited
16. Which of these is NOT a Snowflake cache type?
A. Result cache
B. Local disk cache
C. Metadata cache
D. Transaction cache
17. Which command loads data from stage into a table?
A. COPY INTO table
B. INSERT INTO table
C. LOAD DATA
D. BULK INSERT
18. How can you optimize queries on a large table?
A. Use clustering keys
B. Use SELECT * always
C. Avoid filtering
D. Drop indexes
19. Which object allows tracking inserts, updates, deletes in a table?
A. Table
B. Stream
C. Stage
D. Task
20. How is secure data sharing achieved in Snowflake?
A. Copying the database to a separate account
B. Using secure views and shares
C. Exporting to CSV and sending files
D. Using virtual warehouses
21. Which Snowflake feature prevents sensitive data exposure?
A. Streams
B. Dynamic Data Masking
C. Tasks
D. Time Travel
22. Which of these describes a virtual warehouse scaling option?
A. Scale up — increase cluster size
B. Scale down — decrease table size
C. Scale out — decrease credit usage
D. Scale sideways — repartition database
23. Which is true about multi-cluster warehouses?
A. Handle concurrent queries by running multiple clusters
B. Only used for Snowpipe
C. Duplicate storage per cluster
D. Automatically clone tables
24. How can you monitor warehouse usage and cost?
A. SHOW WAREHOUSE HISTORY
B. RESOURCE MONITORS
C. QUERY_HISTORY & WAREHOUSE_METERING_HISTORY
D. Both B and C
25. In Snowflake, if a parent task fails, what happens to its child task?
A. Child runs anyway
B. Child is skipped automatically
C. Child runs after a delay
D. Child triggers a warehouse scale
Snowflake Quiz Answers (25 Questions)
- B – Cloud-native data warehouse
- B – Centralized cloud storage layer
- B – A compute cluster for executing queries
- B – Automatically partitioning tables into 50–500 MB blocks
- A – Allows rollback of dropped tables within a retention period
- A – Real-time backup for 7 days
- A – Copying data without duplicating storage
- B – After predecessor tasks complete successfully
- B – Tracks changes (CDC) in a table
- A – CREATE PIPE + Snowpipe
- B – Using VARIANT column type + dot notation
- B – Speeds up repeated queries if underlying data hasn’t changed
- B – Independent scaling of compute without affecting storage cost
- B – UNDROP TABLE command
- B – 7 days (standard edition)
- D – Transaction cache
- A – COPY INTO table
- A – Use clustering keys
- B – Stream
- B – Using secure views and shares
- B – Dynamic Data Masking
- A – Scale up — increase cluster size
- A – Handle concurrent queries by running multiple clusters
- D – Both B and C (RESOURCE MONITORS + QUERY_HISTORY/WAREHOUSE_METERING_HISTORY)
- B – Child is skipped automatically
Srinimf 