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;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDMYSCHEMA TO USER USER1;
GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;
GRANT ROLE MYROLE TO USER USER1;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

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

Answer(s): C

Free SnowPro Core Exam Braindumps (page: 80)