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 function can assist with reading data from a Variant datatype with nested elements?

2 / 20

A Stored Procedure can only run as the owner and not the caller?

3 / 20

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

4 / 20

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

5 / 20

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

6 / 20

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

7 / 20

Secure Views and UDFs, bypass optimisations to protect data?

8 / 20

Which of below are NOT valid Snowflake Editions?

9 / 20

Snowpipe requires keypair authentication using JWT?

10 / 20

All tables are natural Clustered based on data ingestion order?

11 / 20

Data Encryption uses a Hierarchical key model?

12 / 20

Once a database is created, we can not transfer ownership of that database to another Role without recreating it?

13 / 20

Files uploaded to staging area using PUT are auto encrypted?

14 / 20

What command is used to place files on a Stage from a local filesystem?

15 / 20

Time Travel can only be defined and used at the Database level?

16 / 20

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

17 / 20

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

18 / 20

Micro Partitions are created based on ingestion order of data within files to be loaded?

19 / 20

Data Shares can only be dropped once approved by a Consumer?

20 / 20

Only a table has a encryption key not a micro partition?

Your score is

0%