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

All data in Snowflake is always protected either at rest or in transit?

2 / 20

Automatic table Clustering can be Suspended and Resumed?

3 / 20

Network Policies can only be assigned at the Account level?

4 / 20

Which best describes the accountadmin Role?

5 / 20

All tables are natural Clustered based on data ingestion order?

6 / 20

When loading data from files into SnowFlake what 2 main factors may impact performance of that load?

7 / 20

Using the context CURRENT_ACCOUNT() could be used to restrict data in a secure view?

8 / 20

A Virtual Warehouse can be assigned to many Resource Monitors?

9 / 20

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

10 / 20

Which languages can UDF's be written in?

11 / 20

During a Data Unload which option can we specify so data is not split into separate files?

12 / 20

Small tables are good candidates for a Clustering Key to be defined on?

13 / 20

Which of the below options of the COPY INTO command can be used with ON_ERROR?

14 / 20

Resource Monitor notifications are sent to all Account Administrators?

15 / 20

Most trial accounts start with 3 letters followed by 10  numbers?

16 / 20

How many days 'maximum' does Time Travel Enterprise Edition and above provide as a limit?

17 / 20

Which of the below are default System defined roles in Snowflake?

18 / 20

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

19 / 20

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

20 / 20

Which of the below are attributes of a Named Stage?

Your score is

0%