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

What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?

A.

0 days

B.

1 day

C.

7 days

D.

14 days

Full Access
Question # 58

What is it called when a customer managed key is combined with a Snowflake managed key to create a composite key for encryption?

A.

Hierarchical key model

B.

Client-side encryption

C.

Tri-secret secure encryption

D.

Key pair authentication

Full Access
Question # 59

Which default warehouse configuration has the highest precedence whenever a new session is created by a user?

A.

Default warehouse tor the user

B.

Default warehouse in the configuration file of the client utilities

C.

Default warehouse specified on a CLI or in drivers/connectors parameters

D.

Default warehouse of the role assigned to the user

Full Access
Question # 60

What object does Snowflake recommend using when planning to unload similarly-formatted data on a regular basis?

A.

Stream

B.

Task

C.

Storage integration

D.

Named file format

Full Access
Question # 61

Which role has the ability to create a share from a shared database by default?

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

ORGADMIN

Full Access
Question # 62

Which file function generates a SnowFlake-hosted URL that must be authenticated when used?

A.

GET_STATE_LOCATION

B.

GET_PRESENT_URL

C.

BUILD_SCOPED_FILE_URL

D.

BUILD_STAGE_FILE_URL

Full Access
Question # 63

Which privilege is required to use the search optimization service in Snowflake?

A.

GRANT SEARCH OPTIMIZATION ON SCHEMA TO ROLE

B.

GRANT SEARCH OPTIMIZATION ON DATABASE TO ROLE

C.

GRANT ADD SEARCH OPTIMIZATION ON SCHEMA TO ROLE

D.

GRANT ADD SEARCH OPTIMIZATION ON DATABASE TO ROLE

Full Access
Question # 64

At what level is the MIN_DATA_RETENSION_TIME_IN_DAYS parameter set?

A.

Account

B.

Database

C.

Schema

D.

Table

Full Access
Go to page: