Special Summer Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

COF-C02 Exam Dumps - SnowPro Core Certification Exam

Go to page:
Question # 177

How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?

A.

60 minutes

B.

24 hours

C.

14 days

D.

30 days

Full Access
Question # 178

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

A.

ARRAY

B.

CHARACTER

C.

STRING

D.

VARCHAR

E.

VARIANT

Full Access
Question # 179

What happens when a network policy includes values that appear in both the allowed and blocked IP address list?

A.

Those IP addresses are allowed access to the Snowflake account as Snowflake applies the allowed IP address list first.

B.

Those IP addresses are denied access lei the Snowflake account as Snowflake applies the blocked IP address list first.

C.

Snowflake issues an alert message and adds the duplicate IP address values lo both 'he allowed and blocked IP address lists.

D.

Snowflake issues an error message and adds the duplicate IP address values to both the allowed and blocked IP address list

Full Access
Question # 180

Which function will provide the proxy information needed to protect Snowsight?

A.

SYSTEMADMIN_TAG

B.

SYSTEM$GET_PRIVATELINK

C.

SYSTEMSALLONTLIST

D.

SYSTEMAUTHORIZE

Full Access
Question # 181

A user has a standard multi-cluster warehouse auto-scaling policy in place.

Which condition will trigger a cluster to shut-down?

A.

When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

B.

When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

C.

When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

D.

When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

Full Access
Question # 182

What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

A.

Enterprise

B.

Business Critical

C.

Standard

D.

Virtual Private Snowflake

Full Access
Question # 183

Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data.

How does Snowflake recommend resolving this issue?

A.

Scale up the existing warehouse.

B.

Create separate warehouses for each user.

C.

Create separate warehouses for each workload.

D.

Stop loading and querying data at the same time.

Full Access
Question # 184

Which pages are included in the Activity area of Snowsight? (Select TWO).

A.

Contacts

B.

Sharing settings

C.

Copy History

D.

Query History

E.

Automatic Clustering History

Full Access
Go to page: