Snowflake Knowledge check Quiz

/20
Created by The Snowman

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

Use of the ORDER BY clause on large datasets can consume vast amounts of Memory and Compute?

2 / 20

Only Enterprise Edition and above can create a Data Share?

3 / 20

Database Replication to Accounts on Lower Editions is possible but only if we use 'IGNORE EDITION CHECK clause' ?

4 / 20

Which of below describes workloads Snowflake can handle best?

5 / 20

The phase 'Scale Out' with regard to Snowflakes means to add more clusters?

6 / 20

Storage is billed as uncompressed data?

7 / 20

Which of the below are examples of unstructured data?

8 / 20

What are the 3 layers in the Snowflake architecture?

9 / 20

COPY INTO Loads are performed as single transaction?

10 / 20

Which of the below can we perform on data when we LOAD into a table in Snowflake?

11 / 20

Resource Monitor notifications are sent to all Account Administrators?

12 / 20

The Cloud Services layer can actually consume billable compute credits?

13 / 20

Stored Procedures can only be written in Python?

14 / 20

Each virtual warehouse is an independent compute cluster but it shares resources with 'other' virtual warehouses?

15 / 20

Which of below could describe Machine Learning & Data Science?

16 / 20

What is Snowsight?

17 / 20

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

18 / 20

Which of the below best describe a File Format ?

19 / 20

The COPY INTO command supports transaction control whereas Snowpipe does not?

20 / 20

Database Replication can be enabled for any existing permanent or transient database?

Your score is

0%