Snowflake SOL-C01 Exam Questions in PDF and Online

QUESTION: 9

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

To modify the schema structure in a session
To create a new schema in a database
To take ownership of an existing schema
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.

Reveal Solution Next Question

QUESTION: 10

Which Snowflake component is responsible for data encryption?

Database storage
Virtual warehouse
Data loading utility
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.

Reveal Solution Next Question

QUESTION: 11

What information is available when previewing a table in Snowsight?

The name of the virtual warehouse where the table is stored
The first 100 rows of the table
The table definition
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.

Reveal Solution Next Question

QUESTION: 12

What is a Markdown cell in Snowflake Notebooks?

A cell that contains data in more than one computer languages
A cell that allows the user to format the cell text
A cell that is nested in other cells
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.

Reveal Solution Next Question

QUESTION: 13

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

To delete a file format
To define the format of data files for processing
To modify an existing file format in a table
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.

Reveal Solution Next Question

QUESTION: 14

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

A directory table
An external table
An external stage
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.

Reveal Solution Next Question

QUESTION: 15

What are Snowflake customers responsible for?

Managing the hardware on which Snowflake is installed
Software installation and updates
Managing table metadata
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.

Reveal Solution Next Question

QUESTION: 16

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

To manage and enforce permissions on objects
To define user tasks
To optimize query execution plans
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.

Reveal Solution Next Question

Snowflake SnowPro Associate: Platform Certification SOL-C01 Exam Questions in PDF

Free Snowflake SOL-C01 Dumps Questions (page: 2)

QUESTION: 9

Explanation:

QUESTION: 10

Explanation:

QUESTION: 11

Explanation:

QUESTION: 12

Explanation:

QUESTION: 13

Explanation:

QUESTION: 14

Explanation:

QUESTION: 15

Explanation:

QUESTION: 16

Explanation: