Snowflake COF-C02 Exam Practice Test Instant Access

Question 1

Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO)

AA user with an USERADMIN or higher role

BA user with a SECURITYADMIN or higher role

CA role that has been granted the ATTACH POLICY privilege

DA role that has the NETWORK_POLlCY account parameter set

EA role that has the CWKERSHIE of the network policy

Answer : B, E

Question 2

Which system_defined, read-only view display information on column lineage that specifies how data flows from source to target in a SQL write operation?

AACCESS_HISTORY

BLOAD_HOSTORY

CQUERY_HISTORY

DCOPY_HISTORY

Answer : A

Question 3

How should a Snowflake use' configure a virtual warehouse to be in Maximized mode''

ASet the WAREHOUSES_SIZE to 6XL.

BSet the STATEMENT_TIMEOUT_1M_SECOMES to 0.

CSet the MAX_CONCURRENCY_LEVEL to a value of 12 or large.

DSet the same value for both MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT.

Answer : D

Question 4

What does Snowflake recommend a user do if they need to connect to Snowflake with a tool or technology mat is not listed in Snowflake partner ecosystem?

AUse Snowflake's native API.

BUse a custom-built connector.

CContact Snowflake Support for a new driver.

DConnect through Snowflake's JDBC or ODBC drivers

Answer : D

Question 5

Which Snowflake database object can be shared with other accounts?

ATasks

BPipes

CSecure User-Defined Functions (UDFs)

DStored Procedures

Answer : C

Question 6

If a virtual warehouse is suspended, what happens lo the warehouse cache?

AThe cache is dropped when the warehouse is suspended and is no longer available upon restart.

BThe warehouse cache persists for as long the warehouse exists, regardless of its suspension status.

CThe cache is maintained for up to two hours and can be restored If the warehouse Is restarted within this limit.

DThe cache is maintained for the auto suspend duration and can be restored it the warehouse 15 restarted within this limit.

Answer : D

Question 7

Which Snowflake table supports unstructured data?

ADirectory

BTransient

CTemporary

DPermanent

Answer : D

Snowflake COF-C02 SnowPro Core Certification Exam Practice Test