Snowflake COF-C02 Exam Actual Questions

Name: SnowPro Core Certification Exam
Brand: QA4Exam
SKU: COF-C02
Price: 30 USD
Availability: InStock
Rating: 4.9 (680 reviews)

The questions for COF-C02 were last updated on Sep 30, 2024.

Viewing page 1 out of 138 pages.
Viewing questions 1-5 out of 691 questions

Unlock Access to All 691 Questions & Answers

Question No. 1

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.

Show Answer

Correct Answer: D

Question No. 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

Show Answer

Correct Answer: A

Question No. 3

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

Show Answer

Correct Answer: B, E

Question No. 4

When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).

AUSAGE on the specific tables in the database.

BUSAGE on the specific tables in the database.

CMODIFY on 1Mb specific tables in the database.

DUSAGE on the database and the schema containing the tables to share

EOPEBATE on the database and the schema containing the tables to share.

Show Answer

Correct Answer: C, D

Question No. 5

Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snowflak?

AACCESS_HOSTORY

BLOGIN_HISTORY

CSESSIONS

DQUERY HISTORY

Show Answer

Correct Answer: B

Unlock All Questions for Snowflake COF-C02 Exam

Full Exam Access, Actual Exam Questions, Validated Answers, Anytime Anywhere, No Download Limits, No Practice Limits

Get All 691 Questions & Answers