Palo Alto Networks

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

Updated On: 19-Apr-2026

Viewing Page 9 of 221 pages.

Download PDF version with 1300 Questions

QUESTION: 36

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

True
False

Answer(s): B

Show Answer Next Question

QUESTION: 37

Which of the following statements are true of Snowflake data loading? (Choose three.)

VARIANT “null” values are not the same as SQL NULL values
It is recommended to do frequent, single row DMLs
It is recommended to validate the data before loading into the Snowflake target table
It is recommended to use staging tables to manage MERGE statements

Answer(s): A,C,D

Show Answer Next Question

QUESTION: 38

Which statements are true of micro-partitions? (Choose two.)

They are approximately 16MB in size
They are stored compressed only if COMPRESS=TRUE on Table
They are immutable
They are only encrypted in the Enterprise edition and above

Answer(s): A,C

Reference:

https://medium.com/weareservian/seeing-snow-for-the-first-time-snowflake-adventures-part-1-731ddc983c69

Show Answer Next Question

QUESTION: 39

True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

True
False

Answer(s): B

Show Answer Next Question

QUESTION: 40

A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)

The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period
The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within previous 24 hour period
The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous 24 hour period
The “24 hour” timer on the precomputed results gets renewed every time the exact query is executed

Answer(s): B,D

Show Answer Next Question

1
…
7
8
9
10
11
…
20
30

Viewing page 9 of 221
Viewing questions 41 - 45 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!