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

Stored Procedures can only be written in Python?

2 / 20

What format does Snowflake store its data?

3 / 20

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

4 / 20

Which of the below are requirements or restrictions for a User Password in Snowflake?

5 / 20

Which of these is NOT a recognised data workload genre?

6 / 20

The COPY INTO command can specify a maximum list of 1000 files to load at a time?

7 / 20

What is the a name of the account type created by the provider and used by a consumer to access a Share using the providers compute?

8 / 20

Which of below are a valid way to see details on views created?

9 / 20

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

10 / 20

Which Port is used for General SnowFlake traffic?

11 / 20

What are the 3 layers in the Snowflake architecture?

12 / 20

Resource Monitor notifications are sent to all Account Administrators?

13 / 20

What are the 2 Auto scaling policies?

14 / 20

Wild card predicate using

LIKE '%string%'

will encourage partition pruning?

15 / 20

A Data Providers is someone who is sharing data?

16 / 20

By default Snowflake blacklists all IP Addresses?

17 / 20

Snowflake Multi Factor Authentication makes use of DUO?

18 / 20

Micro Partitions are immutable, what does this mean?

19 / 20

In the WebUI if we select the Account icon on the main ribbon which options do we then see?

20 / 20

We can use CIDR notation to specify a subnet range for a whitelisted network policy?

Your score is

0%