Palo Alto Networks

Snowflake COF-C02 Exam Questions
SnowPro Core (Page 7 )

Updated On: 19-Apr-2026

Viewing Page 7 of 221 pages.

Download PDF version with 1300 Questions

QUESTION: 26

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

Customers can change the size of the Warehouse after creation
A Warehouse can be resized while running
A Warehouse can be configured to suspend after a period of inactivity
A Warehouse can be configured to auto-resume when new queries are submitted

Answer(s): A,B

Show Answer Next Question

QUESTION: 27

The PUT command: (Choose two.)

Automatically creates a File Format object
Automatically uses the last Stage created
Automatically compresses files using Gzip
Automatically encrypts files

Answer(s): C,D

Reference:

https://docs.snowflake.com/en/sql-reference/sql/put.html

Show Answer Next Question

QUESTION: 28

Which type of table corresponds to a single Snowflake session?

Temporary
Transient
Provisional
Permanent

Answer(s): A

Show Answer Next Question

QUESTION: 29

Which interfaces can be used to create and/or manage Virtual Warehouses?

The Snowflake Web Interface (UI)
SQL commands
Data integration tools
All of the above

Answer(s): D

Show Answer Next Question

QUESTION: 30

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

The Pipe load history is reset to empty
The REFRESH parameter is set to TRUE
Previously loaded files will be ignored
All of the above

Answer(s): A

Show Answer Next Question

1
…
5
6
7
8
9
10
20

Viewing page 7 of 221
Viewing questions 31 - 35 out of 1300 questions

Post your Comments and Discuss Snowflake COF-C02 exam dumps with other Community members:

Comments:

Name:

COF-C02 Exam Discussions & Posts

Community-Verified AI Explanation Commented on April 22, 2026
Question 22:

Correct answer: True (A)

Explanation: Snowflake’s data unload capability allows exporting data from a table to external storage in various file formats, including semi-structured formats like JSON and Parquet. By specifying the FILE_FORMAT option (e.g., JSON or PARQUET), you can unload structured data into these formats for interoperability with other systems or data lakes. The reference doc covers how to prepare and unload data in different formats.

Hyderabad, India

AI Tutor Explanation Commented on April 21, 2026
Question 3:

False is the correct answer (Option B).

Why:

In Snowflake, a database is a metadata object that exists within a single Snowflake account. Accounts are isolated—there isn’t one database that lives in multiple accounts.

You can access data across accounts via data sharing or database replication, but these create separate database objects in the other accounts (e.g., a database in the consumer account created from a share), not a single shared database across accounts.

So a single database cannot exist in more than one Snowflake account.
Thane, India

Community-Verified AI Explanation Commented on April 17, 2026
Question 91:

Answer: B (False)

Explanation:

AWS PrivateLink creates private endpoints inside your VPC to Snowflake’s service endpoints, enabling private connectivity from your AWS resources to Snowflake.

It does not directly provide a secure connection from your on-premises data center to Snowflake. To reach Snowflake from on-prem, you’d typically connect your on-prem network to your AWS VPC (via a VPN or AWS Direct Connect) and then use PrivateLink from that VPC to Snowflake.

Hyderabad, India

Community-Verified AI Explanation Commented on April 15, 2026
Question 13:
Question 13: Which of the following objects can be cloned? (Choose four.)
Correct answers: Tables, Named File Formats, Schemas, Databases (i.e., A, B, C, E)
Reason:

Snowflake supports zero-copy cloning for these object types. A clone is created quickly by copying metadata and pointers to the underlying data, not by duplicating the data itself.

Objects that cannot be cloned (per the options) are Shares and Users.

Examples:

Clone a table: CREATE TABLE new_table CLONE old_table;

Clone a database: CREATE DATABASE new_db CLONE old_db;

Clone a schema: CREATE SCHEMA new_schema CLONE old_schema;

Clone a named file format: CREATE FILE FORMAT new_format CLONE old_format;

Mumbai, India

Community-Verified AI Explanation Commented on April 15, 2026
Question 53:

Answer: False

Explanation:

- Snowflake does not charge data providers an extra fee for creating a data share. - Costs are based on standard storage and compute usage for each party: - Data providers pay for their own storage/compute as usual. - Data consumers pay for their own compute when querying the shared data. - The per-share fee does not exist; sharing is billed like normal Snowflake usage (no additional per-share charge).
Marseille, France

Community-Verified AI Explanation Commented on April 15, 2026
why is not answer D ?
Reason: D (Build the Data Pipeline) does apply in Snowflake migrations.

Snowflake doesn’t use traditional indexes. There are no index objects to migrate, which is why “Migrate Indexes” does not apply.

You still migrate users and schemas, and you almost always build/load pipelines to bring data into Snowflake (ETL/ELT processes), so D is a valid, applicable activity.

So the item that does not apply is C Migrate Indexes, not D.
Marseille, France

Community-Verified AI Explanation Commented on April 15, 2026
Question 41:
Correct answer: C. Scaling out
Explanation:

A multi-cluster warehouse can run multiple compute clusters in parallel to handle concurrent queries.

Increasing the maximum number of clusters allows Snowflake to start more clusters as needed, distributing work across them. This is known as scaling out (horizontal scaling).

Scaling out improves concurrency and reduces wait times when many users run queries at once.

Scaling up, by contrast, would increase the size (resources) of each individual cluster, not the number of clusters.

Notes:

Terms like “scaling rhythmically” or “scaling max” aren’t standard; the core idea here is adding more clusters (scaling out) versus making a single cluster bigger (scaling up).

Marseille, France

Community-Verified AI Explanation Commented on April 15, 2026
Question 4:

Correct answer: B. SECURITYADMIN

Why: The SECURITYADMIN role is designed for security-related tasks, including creating and managing users, roles, and grants. It’s the appropriate role to handle user lifecycle and access control.

What the other roles do (for context):

- SYSADMIN: primarily for managing database objects, warehouses, and compute resources. - ACCOUNTADMIN: has the broadest privileges (full account control) and should be used sparingly. - PUBLIC: a baseline, non-privileged role.

Practical note: To assign or grant privileges to users and roles, you typically operate under SECURITYADMIN (or ACCOUNTADMIN if necessary), keeping security concerns separated from day-to-day object management.

Mumbai, India

Community-Verified AI Explanation Commented on April 13, 2026
Question 128:
Answer: False
Explanation:

ACCOUNTADMIN is the highest-level admin role in Snowflake. Granting a newly created custom role to ACCOUNTADMIN would effectively extend that role’s privileges to the entire account, bypassing the principle of least privilege and jeopardizing separation of duties.

Best practice: create the custom role with only the specific privileges required, then grant that role to the appropriate users or to other roles that need those privileges. Reserve ACCOUNTADMIN for core admin tasks and avoid attaching additional privileges to it.

This approach improves governance and auditing, reduces the risk of privilege abuse, and makes privilege management more manageable.

Hyderabad, India

Community-Verified AI Explanation Commented on April 13, 2026
Question 119:

Answer: True.

Why:

- In Snowflake, a larger warehouse (e.g., 4X-Large) requires provisioning more compute resources (more nodes) than a smaller warehouse (X-Small). This extra provisioning work can take additional time. - If a warehouse is resized while running, Snowflake may need to reallocate resources, which can introduce a brief pause. - Provisioning time can also vary by cloud provider, region, and current load, so the larger size may occasionally take longer to provision than a smaller size.
Hyderabad, India

Community-Verified AI Explanation Commented on April 11, 2026
Question 18:

Answer: False

Why: In Snowflake Secure Data Sharing, a Reader Account is an external account hosted by Snowflake to let partners access shared data. The Data Provider is billed for compute usage in the reader account (compute credits for the warehouses used to run queries), even though the data is read-only. So there are additional compute costs; it’s not zero-cost for the provider.

How to manage: size or pause the reader account’s warehouses to control costs, since query compute in the reader account drives the charges.

Chennai, India

Community-Verified AI Explanation Commented on April 11, 2026
Question 5:

Answer: True

Why: Bulk unloading in Snowflake is done with the COPY INTO command. It supports unloading from a table or from the result of a SELECT statement. Using a SELECT lets you specify exactly which columns and rows to unload (and even compute expressions) before writing to an external stage. For example:

- COPY INTO @stage/path/file.csv FROM (SELECT col1, col2 FROM my_table WHERE date >= '2024-01-01') FILE_FORMAT=(TYPE=CSV);
Chennai, India

So Commented on February 22, 2026
very useful
Anonymous

Community-Verified AI Explanation Commented on February 09, 2026
Excellent resource
Anonymous

AI Tutor

AI Tutor 👋 I’m here to help!