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?

CREATE –

A. PIPE + Snowpipe
B. STREAM
C. TASK
D. ALTER TABLE

---

11. How do you query JSON data in Snowflake?

A. Only by converting JSON to CSV
B. VARIANT column type + dot notation
C. JSON indexes
D. a Separte 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. Using Scale up — increase cluster size
B. By 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. runs anyway
B. is skipped automatically
C. runs after a delay
D. triggers a warehouse scale

Snowflake Quiz Answers (25 Questions)

FAQs

Who is this Snowflake quiz for?

This quiz is for data engineers, data analysts, cloud architects, and anyone preparing for a Snowflake-related interview.

Are the answers included?

Yes, you’ll find a full answer key at the end of this post so you can quickly check your responses.

How do I score this quiz?

Give yourself one point for each correct answer for a maximum score of 25; aim for 20 or more to show strong fundamentals.

How to Use This Quiz

Use this 25-question quiz to check your Snowflake knowledge and get ready for interviews.

1. 1. Answer all 25 questions first. Read each question carefully and choose the option you think is correct.
2. 2. Check your answers against the answer key. Compare your choices with the key at the end and total your score.
3. 3. Review every question you got wrong. Revisit those topics in the Snowflake documentation or other trusted resources.
4. 4. Retake the quiz before your interview. Try it again from memory to confirm you understand the concepts and have improved.