Get Started COF-C02 Exam [2026] Dumps Snowflake PDF Questions [Q181-Q202]

4/5 - (2 votes)

Get Started: COF-C02 Exam [2026] Dumps Snowflake PDF Questions

COF-C02 Premium Exam Engine pdf Download

The SnowPro Core Certification Exam is intended for professionals who work with Snowflake technology and want to demonstrate their expertise in the field. COF-C02 exam covers a wide range of topics, including data loading and unloading, database design, performance optimization, security, and user management. A successful candidate will demonstrate an understanding of Snowflake’s architecture, features, and functions, and will be able to use this knowledge to solve real-world data warehousing problems. SnowPro Core Certification Exam certification exam is a rigorous test of a candidate’s skills and knowledge, and passing it is a significant achievement in the field of data warehousing.

NEW QUESTION 181
How does Snowflake reorganize data when it is loaded? (Select TWO).

Binary format

Columnar format

Compressed format

Raw format

Zipped format

NEW QUESTION 182
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

CREATE_SHARE on the account

SHARE on databases and schemas

SELECT on tables used by the secure view

REFERENCE_USAGE on databases

NEW QUESTION 183
What is the expiration period tor a file URL used to access unstructured data in cloud storage?

The remainder of the session

An unlimited amount of time

The length of time specified in the expiration_time argument

The same length of time as the expiration period for the query results cache

NEW QUESTION 184
Which view can be used to determine if a table has frequent row updates or deletes?

TABLES

TABLE_STORAGE_METRICS

STORAGE_DAILY_HISTORY

STORAGE USAGE

NEW QUESTION 185
What are type predicates used for?

Extracting data from a variant column

Casting a value in a variant column to a particular data type

Determining if a value in a variant column is a particular data type

Manipulating objects and arrays in a VARIANT column

NEW QUESTION 186
True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer’s Snowflake account.

True

False

NEW QUESTION 187
A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?

GRANT ROLE MYROLE TO USER USER1;
CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

GRANT ROLE MYROLE TO USER USER1;
CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

GRANT ROLE MYROLE TO USER USER1;
CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

GRANT ROLE MYROLE TO USER USER1;
CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

NEW QUESTION 188
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

ROLES

POLICY_REFERENCES

QUERY_HISTORY

RESOURCE_MONIT ORS

ACCESS_HISTORY

NEW QUESTION 189
What does an integration between Snowflake and Microsoft Private Link or AWS PrivateLink support?

The isolation of data within a Snowflake account.

The use of Secure Data Sharing among Snowflake accounts.

A Virtual Private Network (VPN) between a user and Snowflake.

A secure, direct connection to Snowflake that does not use the internet.

NEW QUESTION 190
What object or service uses Change Data Capture (CDC) to record Data Manipulation Language (DML) changes made to tables?

Task

Stream

Snowpipe

Event Table

NEW QUESTION 191
Which data types optimally store semi-structured data? (Select TWO).

ARRAY

CHARACTER

STRING

VARCHAR

VARIANT

NEW QUESTION 192
What is a recommended best practice when loading data into Snowflake?

Combine smaller files into larger tiles before loading.

When loading a single large file split it into multiple files before loading.

Set the DATA_RETENTION_TIME_IN_DAYS on the table to 0 before loading.

Make sure the files in the stage are either all compressed or all uncompressed.

NEW QUESTION 193
Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

Configure the user to be initially disabled.

Force an immediate password change.

Set a default role for the user.

Set the number of minutes to unlock to 15 minutes.

Set the user’s access to expire within a specified timeframe.

NEW QUESTION 194
Which object can be used to query the data loading history for the last 365 days for a Snowflake account?

NEW QUESTION 195
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Customer-managed encryption keys through Tri-Secret Secure

Automatic encryption of all data

Up to 90 days of data recovery through Time Travel

Object-level access control

Column-level security to apply data masking policies to tables and views

NEW QUESTION 196
Which task privilege does a Snowflake role need in order to suspend or resume a task?

USAGE

OPERATE

MONITOR

OWNERSHIP

NEW QUESTION 197
Which privilege is required on a virtual warehouse to abort any existing executing queries?

USAGE

OPERATE

MODIFY

MONITOR

NEW QUESTION 198
Which statistics on a Query Profile reflect the efficiency of the query pruning? (Select TWO).

Partitions scanned

Partitions total

Bytes spilled

Bytes scanned

Bytes written

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

Use the DROP command

Use the purge copy option.

Use the FORCE = TRUE parameter

Use the LOAD UNCERTAIN FILES copy option.

NEW QUESTION 200
Which Snowflake data type is used to store JSON key value pairs?

TEXT

BINARY

STRING

VARIANT

NEW QUESTION 201
What are the least privileges needed to view and modify resource monitors? (Select TWO).

SELECT

OWNERSHIP

MONITOR

MODIFY

USAGE

NEW QUESTION 202
What are common issues found by using the Query Profile? (Choose two.)

Identifying queries that will likely run very slowly before executing them

Locating queries that consume a high amount of credits

Identifying logical issues with the queries

Identifying inefficient micro-partition pruning

Data spilling to a local or remote disk

Pass Your Snowflake Exam with COF-C02 Exam Dumps: https://www.surepassexams.com/COF-C02-exam-bootcamp.html

Leave a Reply Cancel reply