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

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

COF-C02 Exam Dumps - SnowPro Core Certification Exam

Go to page:
Question # 185

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

A.

A directory table is a separate database object.

B.

Directory tables store data file metadata.

C.

A directory table will be automatically added to a stage.

D.

Directory tables do not have their own grantable privileges.

E.

Directory table data can not be refreshed manually.

Full Access
Question # 186

What is a characteristic of the Snowflake Query Profile?

A.

It can provide statistics on a maximum number of 100 queries per week.

B.

It provides a graphic representation of the main components of the query processing.

C.

It provides detailed statistics about which queries are using the greatest number of compute resources.

D.

It can be used by third-party software using the Query Profile API.

Full Access
Question # 187

Which user object property requires contacting Snowflake Support in order to set a value for it?

A.

DISABLED

B.

MINS TO BYPASS MFA

C.

MINS TO BYPASS NETWORK POLICY

D.

MINS TO UNLOCK

Full Access
Question # 188

What action can a user take to address query concurrency issues?

A.

Enable the query acceleration service.

B.

Enable the search optimization service.

C.

Add additional clusters to the virtual warehouse

D.

Resize the virtual warehouse to a larger instance size.

Full Access
Question # 189

Which file format will keep floating-point numbers from being truncated when data is unloaded?

A.

CSV

B.

JSON

C.

ORC

D.

Parquet

Full Access
Question # 190

Which stream type can be used for tracking the records in external tables?

A.

Append-only

B.

External

C.

Insert-only

D.

Standard

Full Access
Question # 191

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

1. Created a user called "CONSUMER"

2. Created a database to hold the share and an extra-small warehouse to query the data

3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share

Based on this configuration what is true of the reader account?

A.

The reader account will automatically use the Standard edition of Snowflake.

B.

The reader account compute will be billed to the provider account.

C.

The reader account can clone data the provider has shared, but cannot re-share it.

D.

The reader account can create a copy of the shared data using CREATE TABLE AS...

Full Access
Question # 192

How long does Snowflake retain information in the ACCESS HISTORY view?

A.

7 days

B.

14 days

C.

28 days

D.

365 days

Full Access
Go to page:

Hot Exams

ADM-201 Dumps
Platform-App-Builder Dumps
AZ-500 Dumps
350-701 Dumps
SY0-601 Dumps
NCSE-Core Dumps
PDP9 Dumps
DP-203 Dumps
AZ-700 Dumps
NSE7_EFW-7.0 Dumps
Integration-Architect Dumps
CS0-003 Dumps