Winter Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: v4s65

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

Which of the following describes the Snowflake Cloud Services layer?

A.

Coordinates activities in the Snowflake account

B.

Executes queries submitted by the Snowflake account users

C.

Manages quotas on the Snowflake account storage

D.

Manages the virtual warehouse cache to speed up queries

Full Access
Question # 218

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

A.

The warehouse size does not change until all queries currently running in the warehouse have completed.

B.

The warehouse size does not change until all queries currently in the warehouse queue have completed.

C.

The warehouse size does not change until the warehouse is suspended and restarted.

D.

It does not return from the command until the warehouse has finished changing its size.

Full Access
Question # 219

What is the MAXIMUM size limit for a record of a VARIANT data type?

A.

8MB

B.

16MB

C.

32MB

D.

128MB

Full Access
Question # 220

What privilege should a user be granted to change permissions for new objects in a managed access schema?

A.

Grant the OWNERSHIP privilege on the schema.

B.

Grant the OWNERSHIP privilege on the database.

C.

Grant the MANAGE GRANTS global privilege.

D.

Grant ALL privileges on the schema.

Full Access
Question # 221

The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

A.

In the metadata of the target table for 14 days

B.

In the metadata of the pipe for 14 days

C.

In the metadata of the target table for 64 days

D.

In the metadata of the pipe for 64 days

Full Access
Question # 222

If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?

A.

Table definition

B.

Stage definition

C.

Session level

D.

COPY INTO TABLE statement

Full Access
Question # 223

The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

A.

USERADMIN

B.

PUBLIC

C.

ORGADMIN

D.

SYSADMIN

Full Access
Question # 224

Which items are considered schema objects in Snowflake? (Select TWO).

A.

Pipe

B.

File format

C.

Resource monitor

D.

Storage integration

E.

Virtual warehouse

Full Access
Go to page: