Question 1

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

Options :

A : True

B : False

Answer: A

Question 2

How does Snowflake reorganize data when it is loaded? (Select TWO).

Options :

A : Binary format

B : Columnar format

C : Compressed format

D : Raw format

E : Zipped format

Answer: B,C

Question 3

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

Question 4

How long is the Fail-safe period for temporary and transient tables?

Options :

A : There is no Fail-safe period for these tables.

B : 1 day

C : 7 days

D : 31 days

E : 90 days

Answer: A

Question 5

Which items are considered schema objects in Snowflake? (Select TWO).

Options :

A : Pipe

B : File format

C : Resource monitor

D : Storage integration

E : Virtual warehouse

Answer: A,B

Free COF-C02 Mock Exam – Practice Online Confidently