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

Which options below will create a new database called PSAMMY?

2 / 20

Which of the below options can be used to Improve Query Performance?

3 / 20

Which of below describes workloads Snowflake can handle best?

4 / 20

What does Tri Secret Secure mean?

5 / 20

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

6 / 20

The bigger a Warehouse the larger the cache that Warehouse has to use?

7 / 20

Which of the below COPY INTO options are related to data length?

8 / 20

Which Port is used for General SnowFlake traffic?

9 / 20

What are the 3 layers in the Snowflake architecture?

10 / 20

A permanent table can have Time travel of upto 1 year?

11 / 20

Time Travel is only used to restore a table you can't use it to query a table at a point in the past?

12 / 20

A secure view allows access to tables which are owned by the accountadmin role?

13 / 20

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

14 / 20

Which of these is not a database object in Snowflake?

15 / 20

A Warehouse is charged at a minimum of 60 seconds then per second billing is used?

16 / 20

Which of the below are Valid Snowflake Editions?

17 / 20

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

18 / 20

Which Editions of Snowflake cover SOC2 Type 2, SOC1 TypeII compliance?

19 / 20

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

20 / 20

What determines the maximum file size for data unloads out of Snowflake?

Your score is

0%