Snowflake Knowledge check Quiz

/20
Created by Paul Sammy

Snowflake Quiz basic

SNOWDBA Knowledge Checker Test 1.0

20 Questions chosen at Random to test your knowledge.

 

You have 3 minutes so think fast.

1 / 20

Scaling Out a Multi Cluster Warehouse support which options?

2 / 20

Partner Connect can be described as technology partners that have joined with Snowflake to create an in-account Snowflake wizard?

3 / 20

A UDF function code will contain $$ only at the end to signify end of code?

4 / 20

Every new database created contains 2 schemas what are these called?

5 / 20

In the WebUI if we select the Account icon on the main ribbon which options do we then see?

6 / 20

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

7 / 20

A temporary table can be restored by contacting Snowflake support who will use failsafe?

8 / 20

Database Replication is only supported across the Same Cloud provider i.e. AWS to AWS as the source but to a different or the same region?

9 / 20

Files uploaded to staging area using PUT are auto encrypted?

10 / 20

Which of the below is the smallest Size Warehouse that can be configured?

11 / 20

The SNOWFLAKE database contains information about account usage?

12 / 20

There is a limit of 100 databases that can be replicated per account?

13 / 20

Only a table can be created as transient?

14 / 20

Static partition pruning is based on columns in the WHERE clause?

15 / 20

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

16 / 20

A transient table will be dropped when the user session that created it ends?

17 / 20

Pipes do not support semi structured data?

18 / 20

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

19 / 20

What are the 2 types of Stage in Snowflake?

20 / 20

Stored Procedures can only be written in Python?

Your score is

0%