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 of the below are examples of Technical Partners offerings?

2 / 20

SNOWFLAKE_SAMPLE_DATA is a database share provided for performance testing and learning?

3 / 20

A Materialised View will actually store the result set on disk separate from the underlying table data it queries?

4 / 20

A Encryption Key can be in a state of Retired?

5 / 20

Which of the below are examples of Semi-Structured data?

6 / 20

The Service Layer stores which of the below about each Micro Partition?

7 / 20

Automatic table Clustering can be Suspended and Resumed?

8 / 20

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

9 / 20

What is the maximum size of each micro partition (compressed data)?

10 / 20

Which of the below are table types in Snowflake?

11 / 20

A regular expression can be used with the COPY INTO command to filter the file files to target for load?

12 / 20

Which of the below best describe a File Format ?

13 / 20

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

14 / 20

Which of below describes workloads Snowflake can handle best?

15 / 20

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?

16 / 20

Having a high Time Travel setting can help reduce Storage Costs?

17 / 20

What are the 3 layers in the Snowflake architecture?

18 / 20

Users must manually refresh a Materialised View to keep it's data upto date?

19 / 20

When a task is created it is initially suspended?

20 / 20

Which of the below are Valid Snowflake Editions?

Your score is

0%