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

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 # 241

Which role has the ability to create and manage users and roles?

A.

ORGADMIN

B.

USERADMIN

C.

SYSADMIN

D.

SECURITYADMIN

Full Access
Question # 242

Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

A.

USAGE

B.

OPERATE

C.

MONITOR

D.

MODIFY

Full Access
Question # 243

How long can a data consumer who has a pre-signed URL access data files using Snowflake?

A.

Indefinitely

B.

Until the result_cache expires

C.

Until the retention_time is met

D.

Until the expiration time is exceeded

Full Access
Question # 244

What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

A.

The shared objects are transferred.

B.

The shared objects are copied.

C.

The shared objects become accessible.

D.

The shared objects can be re-shared.

Full Access
Question # 245

A Snowflake user has two tables that contain numeric values and is trying to find out which values are present in both tables. Which set operator should be used?

A.

INTERSECT

B.

MFRCK

C.

MINUS

D.

UNION

Full Access
Question # 246

Which role can create and manage Snowflake accounts?

A.

SYSADMIN

B.

ACCOUNTADMIN

C.

ORGADMIN

D.

SECURITYADMIN

Full Access
Question # 247

The Snowflake VARIANT data type imposes a 16 MB size limit on what?

A.

An individual row

B.

An individual column

C.

A view

D.

A file in a stage

Full Access
Question # 248

What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).

A.

A VARIANT column

B.

A column with very low cardinality

C.

A column with very high cardinality

D.

A column that is most actively used in selective filters

E.

A column that is most actively used in join predicates

Full Access
Go to page: