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

  1. Home
  2. Snowflake
  3. SnowPro Core Certification
  4. COF-C02 - SnowPro Core Certification Exam

COF-C02 Exam Dumps - SnowPro Core Certification Exam

Searching for workable clues to ace the Snowflake COF-C02 Exam? You’re on the right place! ExamCert has realistic, trusted and authentic exam prep tools to help you achieve your desired credential. ExamCert’s COF-C02 PDF Study Guide, Testing Engine and Exam Dumps follow a reliable exam preparation strategy, providing you the most relevant and updated study material that is crafted in an easy to learn format of questions and answers. ExamCert’s study tools aim at simplifying all complex and confusing concepts of the exam and introduce you to the real exam scenario and practice it with the help of its testing engine and real exam dumps

Go to page:
Question # 257

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

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

Full Access
Question # 258

Which governance feature is supported by all Snowflake editions?

A.

Object tags

B.

Masking policies

C.

Row access policies

D.

OBJECT_DEPENDENCIES View

Full Access
Question # 259

Which Snowflake objects are supported by Snowpipe Streaming? (Select TWO)

A.

Temporary tables

B.

Permanent tables

C.

Tables with a default column that is not NULL

D.

Tables with columns containing the GEOMETRY datatype

E.

Tables using sequences to generate names for columns

Full Access
Question # 260

Which schema-level objects allow the user to periodically perform an action under specific conditions, based on data within Snowflake?

A.

Alerts

B.

External tables

C.

Secure views

D.

Materialized views

Full Access
Question # 261

Which command should be used to drop files from an internal or external stage?

A.

DELETE

B.

DROP

C.

REMOVE

D.

TRUNCATE

Full Access
Question # 262

When will Snowflake charge credits for the use of the Cloud Services layer?

A.

Credits will be charged whenever the Cloud Services layer is used.

B.

Credits will be charged only when running a Snowflake-provisioned compute warehouse comfute_wh.

C.

Credits will be charged when the daily consumption of cloud services resources exceeds Wo of the daily warehouse usage.

D.

Credits will be charged only when a virtual warehouse consumes serverless compute services.

Full Access
Question # 263

What is a non-configurable feature that provides historical data that Snowflake may recover during a 7-day period?

A.

Fail-safe

B.

Time Travel

C.

Cloning

D.

Account replication

Full Access
Question # 264

What action should be taken if a large number of concurrent queries are queued in a virtual warehouse?

A.

Scale-up by resizing the warehouse.

B.

Scale-out with a multi-cluster warehouse.

C.

Disable auto-suspend on the warehouse.

D.

Enable auto-resume on the warehouse.

Full Access
Go to page:

Hot Exams

PCNSE Dumps
AZ-900 Dumps
200-301 Dumps
350-401 Dumps
350-701 Dumps
AZ-104 Dumps
CS0-003 Dumps
N10-009 Dumps
SY0-701 Dumps
CAS-005 Dumps
PT0-003 Dumps
ZDTA Dumps