Snowflake Knowledge check Quiz

Using Resource Monitoring can help with Which of the below?

Streams identify and act on changed table records?

Pipes load data into tables continuously from an ingestion queue?

Stored procedures allow the execution of both DDL and DML?

Snowflake Streams hold no data?

Which best describes the sysadmin Role?

Which of the below Roles has the privilege to define Network Policies?

For each securable object, there is a set of privileges that can be granted on it?

Storage is billed as uncompressed data?

Files uploaded to staging area using PUT are auto encrypted?

What 2 settings control when a query will be killed if queued or running to long?

Snowflake warehouse credits have a minimum charge of 31 days unless its a leap year then the minimum charge is 28 days, after which daily billing is implemented?

You can use SQL ID as the basis to set the time that Time Travel will use?

A consumer will use their own Warehouse's compute when accessing a Data Share

A Stored Procedure can only run as the owner and not the caller?

Which of the below entities are not part of a Snowflake database?

A Warehouse is charged at a minimum of 60 seconds then per second billing is used?

Trial accounts can be converted to paid accounts?

It is generally a good sign if we see data  'Spilling' to local disk?

A UDF can return a singular scalar value OR if defined a UDTF can return a set of rows?