Summer Special 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bestdeal

Free Snowflake COF-C02 Practice Exam with Questions & Answers | Set: 14

Questions 196

Which role is responsible for managing the billing and credit data within Snowflake?

Options:
A.

ORGADMIN

B.

ACCOUNTADMIN

C.

SYSADMIN

D.

SECURITYADMIN

Snowflake COF-C02 Premium Access
Questions 197

Which virtual warehouse consideration can help lower compute resource credit consumption?

Options:
A.

Setting up a multi-cluster virtual warehouse

B.

Resizing the virtual warehouse to a larger size

C.

Automating the virtual warehouse suspension and resumption settings

D.

Increasing the maximum cluster count parameter for a multi-cluster virtual warehouse

Questions 198

Which Snowflake feature records changes mace to a table so actions can be taken using that change data capture?

Options:
A.

Materialized View

B.

Pipe

C.

Stream

D.

Task

Questions 199

Which Snowflake feature or tool helps troubleshoot issues in SQL query expressions that commonly cause performance bottlenecks?

Options:
A.

Persisted query results

B.

QUERY_HISTORY View

C.

Query acceleration service

D.

Query Profile

Questions 200

Which system_defined Snowflake role has permission to rename an account and specify whether the original URL can be used to access the renamed account?

Options:
A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

ORGADMIN

Questions 201

How can staged files be removed during data loading once the files have loaded successfully?

Options:
A.

Use the DROP command

B.

Use the purge copy option.

C.

Use the FORCE = TRUE parameter

D.

Use the LOAD UNCERTAIN FILES copy option.

Questions 202

The customer table in the T1 database is accidentally dropped.

Which privileges are required to restore this table? {Select TWO).

Options:
A.

SELECT privilege on the customer table

B.

ownership privilege on the customer table

C.

All privileges on the customer table

D.

All privileges on the T1 database

E.

CREATE TABIE privilege on the T1 database

Questions 203

Given the statement template below, which database objects can be added to a share?(Select TWO).

GRANT ON To SHARE ;

Options:
A.

Secure functions

B.

Stored procedures

C.

Streams

D.

Tables

E.

Tasks

Questions 204

In which hierarchy is tag inheritance possible?

Options:
A.

Organization » Account» Role

B.

Account » User » Schema

C.

Database » View » Column

D.

Schema » Table » Column

Questions 205

While running a query on a virtual warehouse in auto-scale mode, additional clusters are stated immediately if which setting is configured?

Options:
A.

MAX_CLUSTER_COUNT is increased and new_max_clusters is greater than running_clusters

B.

MAX_CLUSTER_COUNT is decreased and new_max_clusters is less than running_clusters

C.

MIN_CLUSTER_COUNT is increased and new_min_clusters is greater than running_clusters

D.

MIN_CLUSTER_COUNT is decreased and new_min_clusters is less than running_clusters

Questions 206

Which type of workload is recommended for Snowpark-optimized virtual warehouses?

Options:
A.

Workloads with ad hoc analytics

B.

Workloads that have large memory requirements

C.

Workloads with unpredictable data volumes for each query

D.

Workloads that are queried with small table scans and selective filters

Questions 207

What does the Activity area of Snowsight allow users to do? (Select TWO).

Options:
A.

Schedule automated data backups.

B.

Explore each step of an executed query.

C.

Monitor queries executed by users in an account.

D.

Create and manage user roles and permissions.

E.

Access Snowflake Marketplace to find and integrate datasets.

Questions 208

A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day. What will happen at the 2< hour mark?

Options:
A.

The file will continue to load until all contents arc loaded.

B.

The tile will slop loading and all data up to that point will be committed.

C.

The file loading could be aborted without any portion of the file being committed.

D.

The file's number of allowable hours to load can be programmatically controlled to load easily into Snowflake

Questions 209

Which statement describes Snowflake tables?

Options:
A.

Snowflake tables arc logical representation of underlying physical data.

B.

Snowflake tables are the physical instantiation of data loaded into Snowflake.

C.

Snowflake tables require that clustering keys be defined lo perform optimally.

D.

Snowflake tables are owned by a use.

Questions 210

A user wants to access stored in a stage without authenticating into Snowflake.

Which type of URL should be used?

Options:
A.

File URL

B.

Staged URL

C.

Scoped URL

D.

Pre-signed URL

Exam Code: COF-C02
Certification Provider: Snowflake
Exam Name: SnowPro Core Certification Exam
Last Update: Jul 10, 2025
Questions: 893

Snowflake Related Exams

How to pass Snowflake SnowPro-Core - SnowPro Core Certification Exam Exam
How to pass Snowflake COF-R02 - SnowPro Core Recertification Exam Exam
SPS-C01 - SnowPro Specialty: Snowpark Certification Exam
ARA-C01 - SnowPro Advanced: Architect Certification Exam
ADA-B01 - SnowPro Advanced: Administrator Certification Exam
ARA-P01 - Practice Exam: Architect
DSA-P02 - Practice Exam: Data Scientist
DEA-P02 - Practice Exam: Data Engineer- ENGLISH ONLY
DSA-C03 - SnowPro Advanced: Data Scientist Certification Exam
SPS-B01 - SnowPro Specialty: Snowpark Beta Certification Exam
DSA-C02 - SnowPro Advanced: Data Scientist Certification Exam
COF-P02 - Practice Exam: Core
DSA-P03 - Practice Exam: Data Scientist
SPS-P01 - Practice Exam: Snowpark
DSA-R03 - SnowPro Advanced: Data Scientist Recertification Exam
Snowflake Free Access
Get Snowflake Full Access

Snowflake Free Exams
Snowflake Free Exams
Access free Snowflake exam study guides and practice tests at Examstrack. Ensure your success with top-notch preparation resources at Examstrack.