IncludeHelp_logo
Skip Navigation Links

Home » Trending Technologies MCQs

Snowflake MCQs (Multiple-Choice Questions)

Practice Snowflake MCQs covering Snowflake architecture, virtual warehouses, databases, schemas, tables, micro-partitions, data loading, Snowpipe, Time Travel, streams, tasks, dynamic tables, Snowpark, data sharing, security, and performance optimization.

Snowflake MCQs

These Snowflake multiple-choice questions are designed to test your understanding of the cloud data platform, its architecture, SQL capabilities, data engineering features, governance, and analytics workloads.

List of Snowflake MCQs

The following questions cover fundamental as well as advanced Snowflake concepts and features.

1. What is Snowflake primarily used for?

  1. Cloud-based data storage, processing, and analytics
  2. Operating system development
  3. Web browser development
  4. Network routing

Answer: A) Cloud-based data storage, processing, and analytics

Explanation:

Snowflake is a cloud data platform that provides storage, compute, data engineering, analytics, and data sharing capabilities.

2. Which architectural characteristic allows Snowflake storage and compute to scale independently?

  1. Separation of storage and compute
  2. Single-node architecture
  3. Local-only storage
  4. Static resource allocation

Answer: A) Separation of storage and compute

Explanation:

Snowflake separates persistent data storage from compute resources, allowing compute capacity to be scaled independently for different workloads.

3. What is a virtual warehouse in Snowflake?

  1. A cluster of compute resources used to execute queries and other workloads
  2. A physical data center
  3. A database schema
  4. A storage file format

Answer: A) A cluster of compute resources used to execute queries and other workloads

Explanation:

A virtual warehouse provides compute resources for SQL queries, DML operations, loading, unloading, and supported Snowpark workloads.

4. What is a major benefit of having separate virtual warehouses for different workloads?

  1. Workloads can use independent compute resources
  2. All workloads must use the same CPU resources
  3. Data is automatically duplicated
  4. Tables are automatically deleted

Answer: A) Workloads can use independent compute resources

Explanation:

Each virtual warehouse is an independent compute cluster, so one warehouse's workload does not directly consume the compute resources of another warehouse.

5. Which Snowflake component provides services such as query parsing, optimization, authentication, and metadata management?

  1. Cloud services layer
  2. Virtual warehouse only
  3. Stage layer
  4. Micro-partition layer

Answer: A) Cloud services layer

Explanation:

The cloud services layer coordinates activities across Snowflake, including authentication, query parsing and optimization, metadata management, and access control.

6. Which Snowflake object is used to organize tables, views, stages, and other objects?

  1. Schema
  2. Warehouse
  3. Cluster
  4. Stream

Answer: A) Schema

Explanation:

A schema is a logical container within a database that can contain objects such as tables, views, stages, functions, and procedures.

7. What is the relationship between a database and schema in Snowflake?

  1. A database contains schemas
  2. A schema contains databases
  3. A warehouse contains schemas
  4. A table contains databases

Answer: A) A database contains schemas

Explanation:

Snowflake uses a hierarchical namespace in which databases contain schemas, and schemas contain database objects.

8. What are micro-partitions in Snowflake?

  1. Automatically managed contiguous units of table storage
  2. User-created database schemas
  3. Virtual warehouses
  4. SQL query sessions

Answer: A) Automatically managed contiguous units of table storage

Explanation:

Snowflake automatically divides table data into micro-partitions. Metadata about these micro-partitions helps the query engine perform efficient data pruning.

9. What type of storage organization is used inside Snowflake micro-partitions?

  1. Columnar
  2. HTML-based
  3. Row-only text files
  4. XML hierarchy

Answer: A) Columnar

Explanation:

Rows are mapped into micro-partitions that are organized in a columnar fashion, which supports efficient analytical query processing.

10. What is micro-partition pruning?

  1. Skipping micro-partitions that cannot contain rows relevant to a query
  2. Deleting old micro-partitions permanently
  3. Creating new virtual warehouses
  4. Encrypting table data

Answer: A) Skipping micro-partitions that cannot contain rows relevant to a query

Explanation:

Snowflake stores metadata about micro-partitions, including value ranges, which allows queries to avoid scanning irrelevant micro-partitions.

11. Which SQL command creates a database in Snowflake?

  1. CREATE DATABASE
  2. NEW DATABASE
  3. MAKE DATABASE
  4. BUILD DATABASE

Answer: A) CREATE DATABASE

Explanation:

Snowflake supports the standard SQL-style CREATE DATABASE statement for creating databases.

12. Which SQL statement creates a table?

  1. CREATE TABLE
  2. NEW TABLE
  3. BUILD TABLE
  4. MAKE TABLE

Answer: A) CREATE TABLE

Explanation:

The CREATE TABLE statement is used to define a new table and its columns.

13. Which Snowflake feature allows querying previous versions of changed or deleted data?

  1. Time Travel
  2. Snowpipe
  3. Snowpark
  4. Clustering

Answer: A) Time Travel

Explanation:

Snowflake Time Travel allows users to access historical data within the applicable retention period, including data that has been changed or deleted.

14. Which clause is commonly used to query a previous point in time in Snowflake?

  1. AT or BEFORE
  2. PAST
  3. HISTORY AT
  4. RESTORE TO

Answer: A) AT or BEFORE

Explanation:

Snowflake Time Travel syntax supports constructs such as AT and BEFORE for querying historical data.

15. What is Fail-safe in Snowflake?

  1. A separate recovery mechanism available after the Time Travel period for eligible data
  2. A query optimization feature
  3. A virtual warehouse type
  4. A table clustering method

Answer: A) A separate recovery mechanism available after the Time Travel period for eligible data

Explanation:

Fail-safe provides Snowflake-managed historical data recovery after the applicable Time Travel retention period, subject to Snowflake's policies and limitations.

16. What is zero-copy cloning in Snowflake?

  1. Creating a clone without initially copying the underlying data
  2. Copying every row into a new physical database
  3. Deleting the source table after cloning
  4. Moving data to another cloud provider

Answer: A) Creating a clone without initially copying the underlying data

Explanation:

Snowflake cloning can create databases, schemas, and tables quickly without initially duplicating the underlying storage. Changes made later can cause additional storage to be consumed.

17. Which command can create a clone of a table?

  1. CREATE TABLE ... CLONE
  2. COPY TABLE ... NEW
  3. CLONE TABLE ... COPY
  4. CREATE TABLE ... DUPLICATE

Answer: A) CREATE TABLE ... CLONE

Explanation:

Snowflake supports syntax such as CREATE TABLE target CLONE source for cloning tables.

18. What is a stage in Snowflake?

  1. A location used to store or reference files for loading and unloading data
  2. A compute cluster
  3. A database schema
  4. A query optimization algorithm

Answer: A) A location used to store or reference files for loading and unloading data

Explanation:

Stages provide locations for data files that can be loaded into Snowflake tables or unloaded from Snowflake.

19. Which command loads data from staged files into a Snowflake table?

  1. COPY INTO
  2. LOAD DATA ONLY
  3. INSERT FILES
  4. IMPORT INTO

Answer: A) COPY INTO

Explanation:

The COPY INTO command is commonly used to load data from staged files into Snowflake tables.

20. Which command can unload table data into files in a stage?

  1. COPY INTO
  2. UNLOAD TABLE
  3. EXPORT FILES
  4. WRITE TO STAGE

Answer: A) COPY INTO

Explanation:

COPY INTO is also used for unloading data from Snowflake tables to staged files.

21. What is Snowpipe designed for?

  1. Continuous or near-continuous loading of new files into Snowflake
  2. Creating virtual warehouses
  3. Managing SQL roles
  4. Creating database schemas

Answer: A) Continuous or near-continuous loading of new files into Snowflake

Explanation:

Snowpipe is designed to load newly arrived files into Snowflake continuously or as close to real time as the ingestion architecture permits.

22. Which Snowflake feature loads row-level data continuously with low latency using SDKs or a REST API?

  1. Snowpipe Streaming
  2. Time Travel
  3. Zero-Copy Clone
  4. Materialized View

Answer: A) Snowpipe Streaming

Explanation:

Snowpipe Streaming is designed for continuous low-latency ingestion of row-level data directly into Snowflake tables.

23. What is a file format object used for in Snowflake?

  1. Defining the format and parsing options for staged data files
  2. Defining compute cluster size
  3. Creating user roles
  4. Creating SQL warehouses

Answer: A) Defining the format and parsing options for staged data files

Explanation:

File format objects define properties used to interpret files such as CSV, JSON, Avro, ORC, and Parquet.

24. Which format is commonly used for semi-structured data in Snowflake?

  1. JSON
  2. TXT only
  3. HTML only
  4. CSS only

Answer: A) JSON

Explanation:

Snowflake supports semi-structured data formats such as JSON and provides data types and functions for working with them.

25. Which Snowflake data type is commonly used to store semi-structured data such as JSON?

  1. VARIANT
  2. INTEGER
  3. BOOLEAN
  4. DATE

Answer: A) VARIANT

Explanation:

The VARIANT data type can store semi-structured data such as JSON.

26. Which data type can be used to store arrays in Snowflake?

  1. ARRAY
  2. INTEGER
  3. NUMBER
  4. DATE

Answer: A) ARRAY

Explanation:

Snowflake provides the ARRAY data type for storing ordered collections of values.

27. Which data type can represent key-value structured data in Snowflake?

  1. OBJECT
  2. NUMBER
  3. FLOAT
  4. DATE

Answer: A) OBJECT

Explanation:

The OBJECT type represents key-value data and is commonly used with semi-structured data.

28. What is a Snowflake stream?

  1. An object that records changes made to a source object
  2. A virtual warehouse
  3. A data file format
  4. A database schema

Answer: A) An object that records changes made to a source object

Explanation:

A stream records data manipulation changes such as inserts, updates, and deletes and exposes change information for change-data-capture workflows.

29. What does CDC stand for in Snowflake data engineering?

  1. Change Data Capture
  2. Cloud Data Cluster
  3. Continuous Database Creation
  4. Central Data Cache

Answer: A) Change Data Capture

Explanation:

Change Data Capture identifies changes made to source data so downstream systems or transformations can process only the changed information.

30. What is a Snowflake task?

  1. An object used to execute SQL or procedural logic according to defined conditions or schedules
  2. A table storage format
  3. A virtual warehouse
  4. A file compression algorithm

Answer: A) An object used to execute SQL or procedural logic according to defined conditions or schedules

Explanation:

Tasks can automate data-processing operations and can be scheduled or organized into task graphs.

31. Which feature is designed for declarative SQL-based data pipelines that automatically refresh according to a target freshness requirement?

  1. Dynamic tables
  2. Stages
  3. Roles
  4. Sequences

Answer: A) Dynamic tables

Explanation:

Dynamic tables let users define the desired result using a SELECT statement while Snowflake manages refreshes and dependencies based on the configured freshness target.

32. Which parameter defines the freshness goal for a Snowflake dynamic table?

  1. TARGET_LAG
  2. MAX_REFRESH
  3. DATA_INTERVAL
  4. STREAM_RATE

Answer: A) TARGET_LAG

Explanation:

TARGET_LAG specifies the freshness target for a dynamic table. It is a freshness goal rather than a simple fixed execution interval.

33. Which approach is generally preferred when a Snowflake pipeline requires procedural logic such as MERGE, stored procedures, or custom orchestration?

  1. Streams and tasks
  2. Dynamic tables only
  3. Materialized views only
  4. Stages only

Answer: A) Streams and tasks

Explanation:

Snowflake documentation distinguishes streams and tasks as an option for procedural logic and custom orchestration, while dynamic tables are designed for declarative SQL pipelines.

34. Which Snowflake feature is intended primarily to accelerate repeated queries against a single base table?

  1. Materialized view
  2. Stream
  3. Task
  4. Stage

Answer: A) Materialized view

Explanation:

Materialized views store precomputed results and can accelerate repeated queries against a base table. Snowflake distinguishes this use case from multi-step pipeline construction.

35. What is Snowpark?

  1. A developer framework for processing data using languages such as Python, Java, and Scala
  2. A Snowflake storage format
  3. A SQL warehouse type
  4. A database backup system

Answer: A) A developer framework for processing data using languages such as Python, Java, and Scala

Explanation:

Snowpark allows developers to build data-processing applications using supported programming languages while executing workloads within Snowflake's platform.

36. Which language is commonly supported by Snowpark?

  1. Python
  2. HTML
  3. CSS
  4. XML only

Answer: A) Python

Explanation:

Snowpark provides APIs for languages including Python, Java, and Scala.

37. What is Snowflake Secure Data Sharing?

  1. A mechanism for sharing selected Snowflake data objects with other accounts without copying the underlying data
  2. A method for duplicating databases between users
  3. A file compression system
  4. A virtual warehouse scaling feature

Answer: A) A mechanism for sharing selected Snowflake data objects with other accounts without copying the underlying data

Explanation:

Secure Data Sharing allows providers to share selected objects with consumers, and Snowflake states that data shared between accounts is not actually copied or transferred between accounts.

38. What happens to objects shared through Snowflake Secure Data Sharing from the consumer's perspective?

  1. The shared objects are read-only
  2. The consumer automatically owns the source data
  3. The consumer can delete the provider's tables
  4. The consumer receives a physical copy by default

Answer: A) The shared objects are read-only

Explanation:

Objects shared between accounts through Secure Data Sharing are read-only to the consumer; the consumer cannot modify or delete the shared source objects.

39. Which Snowflake object can help protect underlying data and business logic when sharing data?

  1. Secure view
  2. Temporary stage only
  3. Virtual warehouse
  4. Sequence

Answer: A) Secure view

Explanation:

Secure views can be used to expose controlled query results while protecting the underlying data and business logic in data-sharing scenarios.

40. What is a row access policy used for in Snowflake?

  1. Controlling which rows a user can see or access
  2. Changing the size of a warehouse
  3. Compressing micro-partitions
  4. Scheduling a task

Answer: A) Controlling which rows a user can see or access

Explanation:

Row access policies provide row-level security by determining which rows are visible or accessible based on policy conditions.

41. What is a masking policy used for?

  1. Protecting sensitive column values by controlling how they are exposed
  2. Creating a new virtual warehouse
  3. Partitioning tables
  4. Scheduling queries

Answer: A) Protecting sensitive column values by controlling how they are exposed

Explanation:

Masking policies provide column-level security by controlling how sensitive column values are presented at query time.

42. What is role-based access control (RBAC) used for in Snowflake?

  1. Assigning privileges through roles
  2. Compressing data files
  3. Creating micro-partitions
  4. Increasing query memory automatically

Answer: A) Assigning privileges through roles

Explanation:

Snowflake uses roles and privileges to control access to databases, schemas, tables, views, warehouses, and other objects.

43. Which Snowflake feature can improve query performance on very large tables by organizing data around specified columns?

  1. Clustering keys
  2. Streams
  3. Tasks
  4. Roles

Answer: A) Clustering keys

Explanation:

Clustering keys can improve pruning and query performance for certain large tables by influencing how data is organized within micro-partitions.

44. Which Snowflake feature can automatically scale the number of compute clusters in a warehouse to handle concurrency?

  1. Multi-cluster warehouse
  2. Time Travel
  3. Stream
  4. Secure View

Answer: A) Multi-cluster warehouse

Explanation:

Multi-cluster warehouses can add or remove compute clusters according to workload and concurrency requirements.

45. Why can warehouse auto-suspend reduce Snowflake compute costs?

  1. It stops an idle warehouse from consuming compute resources
  2. It deletes the database
  3. It removes table data
  4. It disables Time Travel

Answer: A) It stops an idle warehouse from consuming compute resources

Explanation:

Auto-suspend can suspend a warehouse after a period of inactivity, preventing unnecessary compute usage while the warehouse is idle.

46. Which Snowflake feature provides information about executed queries and their performance?

  1. Query History
  2. Time Travel
  3. File Format
  4. Stage

Answer: A) Query History

Explanation:

Query History provides information about executed queries and can be used to investigate execution time, resource usage, errors, and performance.

47. A table contains billions of rows, and a query filters on a column whose values are well organized across micro-partitions. Which Snowflake mechanism can reduce the amount of data scanned?

  1. Micro-partition pruning
  2. Time Travel
  3. Secure Data Sharing
  4. Role inheritance

Answer: A) Micro-partition pruning

Explanation:

Snowflake uses metadata about micro-partitions to determine which partitions can be skipped for a query, reducing unnecessary scanning.

48. A pipeline must detect inserts, updates, and deletes from a source table and then process only the changed rows. Which Snowflake feature is directly designed for this requirement?

  1. Stream
  2. Materialized view
  3. Virtual warehouse
  4. Clustering key

Answer: A) Stream

Explanation:

A Snowflake stream records DML changes to a source object and exposes change information that can be consumed in change-data-capture pipelines.

49. A data team needs a declarative pipeline consisting of several SQL transformations, joins, and aggregations, with Snowflake automatically maintaining the results according to a freshness target. Which feature is most appropriate?

  1. Dynamic tables
  2. Streams only
  3. Virtual warehouses only
  4. Secure views only

Answer: A) Dynamic tables

Explanation:

Dynamic tables are designed for declarative SQL pipelines. Snowflake manages refresh timing, dependency ordering, and incremental processing according to the defined target freshness.

50. A company needs to ingest continuously arriving data, transform it incrementally, maintain historical versions, enforce row and column-level security, and share governed datasets with external Snowflake accounts. Which combination of Snowflake capabilities best supports this architecture?

  1. Snowpipe Streaming, dynamic tables or streams and tasks, Time Travel, data protection policies, and Secure Data Sharing
  2. Only virtual warehouses and temporary tables
  3. Only materialized views and stages
  4. Only SQL worksheets and database schemas

Answer: A) Snowpipe Streaming, dynamic tables or streams and tasks, Time Travel, data protection policies, and Secure Data Sharing

Explanation:

Snowflake provides separate capabilities for continuous ingestion, incremental transformation, historical data access, fine-grained security, and governed cross-account sharing. The appropriate combination depends on the specific pipeline and governance requirements.

Comments and Discussions!

Load comments ↻



Top MCQs
Top Programs/Examples
Top Tutorials
About
Student's Section
Subscribe

Copyright © 2026 www.includehelp.com. All rights reserved.