Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. SnowPro Associate Platform SOL-C01

Snowflake SnowPro Associate Platform SOL-C01 Exam Questions
SnowPro Associate Platform SOL-C01 (Page 3 )

Updated On: 29-Apr-2026
Page 3 of 28
PDF with 119 Questions

What is the purpose of the USE SCHEMA command in Snowflake?

  1. To modify the schema structure in a session
  2. To create a new schema in a database
  3. To take ownership of an existing schema
  4. To set the current schema for a session

Answer(s): D

Explanation:

The USE SCHEMA command sets the active schema context for the current session. After it is executed, any unqualified object names (for example, SELECT * FROM my_table) are resolved within that schema. This reduces the need to fully qualify object names with database and schema each time and ensures that statements reference the expected logical container.

CREATE SCHEMA is used to create a new schema. ALTER SCHEMA and GRANT OWNERSHIP are used to modify schema properties or transfer ownership, respectively. USE SCHEMA does not alter structure or ownership; it simply changes the context in which subsequent SQL statements are interpreted.



Which Snowflake component is responsible for data encryption?

  1. Database storage
  2. Virtual warehouse
  3. Data loading utility
  4. Cloud services

Answer(s): A

Explanation:

Snowflake's database storage layer is responsible for encrypting data at rest. All persisted data-- whether structured, semi-structured, or unstructured--is encrypted using strong encryption algorithms such as AES-256. This process is automatic and transparent to users, ensuring that files and micro-partitions stored in Snowflake-managed cloud storage are encrypted by default. Data in transit is protected separately through TLS.

Virtual warehouses provide compute resources to execute queries and do not perform storage-level encryption. Data loading utilities (such as COPY INTO and client tools) orchestrate data movement but do not handle at-rest encryption. The Cloud Services layer manages metadata, session management, security policies, and query optimization, but the actual encryption of stored data is part of the storage subsystem.



What information is available when previewing a table in Snowsight?

  1. The name of the virtual warehouse where the table is stored
  2. The first 100 rows of the table
  3. The table definition
  4. The Entity Relationship (ER) diagram for the table

Answer(s): B

Explanation:

When you preview a table in Snowsight, Snowflake returns up to the first 100 rows of the table's data. This preview is designed for quick inspection of the table's contents and structure without requiring the user to manually write a SELECT query. The preview interface allows basic exploration such as scrolling, simple sorting, and viewing column metadata.

Tables are not "stored" in a specific virtual warehouse; warehouses provide compute only. The table definition (DDL) can be viewed in the Table Details section but is not the main output of the Preview action. Snowsight does not natively generate an Entity Relationship (ER) diagram for the table as part of the preview.



What is a Markdown cell in Snowflake Notebooks?

  1. A cell that contains data in more than one computer languages
  2. A cell that allows the user to format the cell text
  3. A cell that is nested in other cells
  4. A cell that contains older data

Answer(s): B

Explanation:

In Snowflake Notebooks, a Markdown cell is a non-executable cell type used for formatted text. It allows the user to format text using Markdown syntax, including headings, lists, tables, emphasis, inline code, and links. This makes it possible to document the analysis, describe steps, and provide commentary alongside SQL and Python cells, improving clarity and collaboration.

Markdown cells do not execute code in "more than one computer language"; they are not code cells at all. Notebook cells are not nested; each cell exists as a separate element in the notebook. There is no concept of "older data" associated specifically with Markdown cells; they simply store text content defined by the user.



What is the CREATE FILE FORMAT command used for in Snowflake?

  1. To delete a file format
  2. To define the format of data files for processing
  3. To modify an existing file format in a table
  4. To create a new table

Answer(s): B

Explanation:

The CREATE FILE FORMAT command creates a file format object in Snowflake that defines how data files should be interpreted when loading or unloading. Parameters in the definition include file type (for example, CSV, JSON, PARQUET), field delimiters, compression, quoting rules, and other parsing options. Once created, this file format object can be referenced by COPY INTO commands or external table definitions to ensure consistent handling of files.

Deleting a file format is performed using DROP FILE FORMAT. Modifying an existing file format is done with ALTER FILE FORMAT. Creating a new table is achieved with CREATE TABLE. Therefore, the purpose of CREATE FILE FORMAT is specifically to define how Snowflake should process data files.



What Snowflake object provides a secure connection to external cloud storage?

  1. A directory table
  2. An external table
  3. An external stage
  4. A named file format

Answer(s): C

Explanation:

An external stage is the Snowflake object that encapsulates a secure connection to external cloud storage such as Amazon S3, Azure Blob Storage, or Google Cloud Storage. It stores the location (URL or bucket path) and, where required, credentials or role-based access configuration, and may also reference a file format. External stages are used as the source or target for COPY INTO operations when loading from or unloading to external storage.

An external table provides a logical SQL interface to data stored externally but relies on a stage for connectivity; it does not itself define the connection. A directory table exposes metadata about files stored in a stage, not the connection. A named file format defines parsing rules (type, delimiter, compression) but has no knowledge of or connection to a specific external storage location.



What are Snowflake customers responsible for?

  1. Managing the hardware on which Snowflake is installed
  2. Software installation and updates
  3. Managing table metadata
  4. Loading, unloading, and managing data

Answer(s): D

Explanation:

As a fully managed cloud data platform, Snowflake is responsible for infrastructure provisioning, hardware, software installation, platform upgrades, scaling, and internal metadata management such as micro-partitions and statistics. Customers do not manage physical hardware or install Snowflake software.

Customers are responsible for their data and its lifecycle within Snowflake. This includes loading data into tables from internal and external sources, unloading data when required, organizing data structures (databases, schemas, tables), defining access controls, and managing how data is used, transformed, and governed. They design schemas and workloads but do not manage the underlying engine. Therefore, "Loading, unloading, and managing data" correctly describes the customer's responsibility.



What is the purpose of assigning roles to users in Snowflake?

  1. To manage and enforce permissions on objects
  2. To define user tasks
  3. To optimize query execution plans
  4. To control which data types users can query

Answer(s): A

Explanation:

Snowflake uses a Role-Based Access Control (RBAC) model, whererolesare the containers of privileges. Assigning roles to users ensures that permissions on database objects (such as tables, schemas, warehouses, and functions) are enforced consistently and securely. Users do not receive privileges directly; instead, privileges are granted to roles, and roles are assigned to users.

This enables scalable, auditable, and manageable access control.

Roles do not determine tasks, do not affect query optimization, and do not govern which data types a user may query--permissions are object-based, not datatype-based.



Viewing page 3 of 28
Viewing questions 17 - 24 out of 119 questions
Share your experience with other


SnowPro Associate Platform SOL-C01 Exam Discussions & Posts

AI Tutor AI Tutor 👋 I’m here to help!