Snowflake Knowledge check Quiz

Tasks can execute multiple DML statements?

Which options below will create a new database called PSAMMY?

It is for the customer to manage the Snowflake Object Storage used for the database tables by working with the Cloud provider such as AWS?

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

Which Data type is great for storing semi-structured data?

How often does Snowflake rotate Encryption keys?

Standard Edition provides support for HIPAA, PCI, FedRAMP?

Only a table can be created as transient?

Its possible to kill a running query from the WebUI using 'Abort'

Encryption Key Rotation will cause downtime so must be done during the users Maintenance Window?

In a Network policy if we Whitelist something then everything else is automatically blacklisted?

Defining a Clustering Key can override natural clustering on a table?

Multi Factor Authentication can be used with which of the below?

Snowflake has a default file format if none is explicitly set?

Which best describes the accountadmin Role?

Failsafe supports all table types as long as the customer is running on Enterprise Edition or above?

If we define a Clustering Key Snowflakes keeps the clustering order updated in background and the user is charged for this service?

Time Travel is NOT available in Standard Edition?

Federated Authentication is not possible in Snowflake?

For a warehouse if MAX Clusters = 1 then we have a scale out Multi-Cluster setup?