Snowflake Knowledge check Quiz

Which of the below are valid services managed by the Service Layer?

Warehouses assigned to Resource Monitor are suspended and cannot be resumed until which of following?

When using a 'Group by' clause try to group on something that has many distinct values?

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

Multi Factor Authentication should be enabled on users with which role?

Which of below could describe Machine Learning & Data Science?

Customers must define a maintenance window for which Snowflake can use to allow downtime needed to apply patch updates?

The SNOWFLAKE Account Usage Share contains information about a users account like query history?

When we Unload data which of below are valid Parquet file format options?

Stored Procedures can only be written in Javascript?

Which of the options for the COPY INTO command below are related to reloading a file that may have already been loaded?

A multi Cluster warehouse setup may be beneficial for lots of concurrent users and queries?

Which of these Cloud Providers does Snowflake support?

Stored procedures allow the execution of both DDL and DML?

Enabling replication designates the source database as a standby database?

Zero Copy Cloning allows which of below?

Time Travel can only be defined and used at the Database level?

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?

Snowflake data is automatically replicated across how many Availability Zones (Data Centres)?

Uncorrelated Scalar Subqueries generally run faster than Correlated Scalar Subqueries?