Free COF-C02 Exam braindumps download (COF-C02 exam dumps Free)

Which of the following conditions must be met in order to return results from the results cache? (Choose two.)

The user has the appropriate privileges on the objects associated with the query.
Micro-partitions have been reclustered since the query was last run.
The new query is run using the same virtual warehouse as the previous query.
The query includes a User Defined Function (UDF).
The query has been run within 24 hours of the previously-run query.

Answer(s): A,E

Which statement about billing applies to Snowflake credits?

Credits are billed per-minute with a 60-minute minimum.
Credits are used to pay for cloud data storage usage.
Credits are consumed based on the number of credits billed for each hour that a warehouse runs.
Credits are consumed based on the warehouse size and the time the warehouse is running.

Answer(s): D

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

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

Answer(s): A

What is the purpose of multi-cluster virtual warehouses?

To create separate data warehouses to increase query optimization
To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
To eliminate or reduce queuing of concurrent queries
To allow the warehouse to resize automatically

Answer(s): C