Confidently Practice Online with Free COF-C02 Exam Cram

Practice your SnowPro Core Certification certification test with free COF-C02 exam cram and take control of your certification preparation. At FreeExamCram, you can practice online for free using real COF-C02 exam dumps, verified questions, and expert-designed free online practice tests. Moreover our Snowflake COF-C02 exam cram backed by our confidence-boosting refund guarantee.

Question 1

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

Options :

A : ACCOUNTADMIN

B : SECURITYADMIN

C : SYSADMIN

D : ORGADMIN

Answer: A

Question 2

Which resource monitor setting will cancel all active queries in a virtual warehouse when the threshold is met?

Options :

A : NOTIF

B : NOTIFY_USERS

C : SUSPEND

D : SUSPEND_IMMEDIATE

Answer: D

Question 3

What command is used to export or unload data from Snowflake?

Options :

A : PUT @mystage

B : GET @mystage

C : COPY INTO @mystage

D : INSERT @mystage

Answer: A

Question 4

Who can access the data published in a Data Exchange?

Options :

A : Only the data provider who published the data

B : Any Snowflake user, regardless of their role or permissions

C : Any user who has been provided with a unique Data Exchange URL

D : Only the users that the data provider has invited to the Data Exchange

Answer: D

Question 5

A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

Options :

A : GRANT ROLE MYROLE TO USER USER1;

GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

B : GRANT ROLE MYROLE TO USER USER1;

GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

C : GRANT ROLE MYROLE TO USER USER1;

GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K"-'SCHEMA TO USER! ;

D : GRANT ROLE MYROLE TO USER USER1;

GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Answer: A