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 function can be used to convert semi-structured data into rows and columns?

Options :

A : TABLE

B : FLATTEN

C : PARSE_JSON

D : JSON EXTRACT PATH TEXT

Answer: B

Question 2

Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

Options :

A : USAGE

B : OPERATE

C : MONITOR

D : MODIFY

Answer: B

Question 3

In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?

Options :

A : Cloud Services

B : Database Storage

C : Query Processing

D : Metadata Management

Answer: B

Question 4

What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).

Options :

A :

If a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role.

B :

If no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role.

C :

If no role was specified as part of the connection and a default role has not been set for the Snowflake user, the session will not be initiated and the log in will fail.

D :

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, it will be ignored and the default role will become the current role.

E :

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, the role is automatically granted and it becomes the current role.

Answer: A,B

Question 5

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