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 Port is used for General SnowFlake traffic?

2 / 20

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

3 / 20

For a warehouse if MAX Clusters = 1 then we have a scale out Multi-Cluster setup?

4 / 20

A larger type Warehouse size may be needed for?

5 / 20

The Snowflake account URL to logon is composed of which of the below?

6 / 20

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

7 / 20

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

8 / 20

Who are two of the founding members of Snowflake?

9 / 20

Stored Procedures can only be written in Python?

10 / 20

What are the 2 Auto scaling policies?

11 / 20

If a Virtual Warehouse is stopped, we can preserve its cache with the WRITE_CACHE_TO_DISK clause?

12 / 20

The Cloud Services layer can actually consume billable compute credits?

13 / 20

Which of the below are attributes of a Named Stage?

14 / 20

By default Snowflake blacklists all IP Addresses?

15 / 20

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

16 / 20

Scaling Out a Multi Cluster Warehouse support which options?

17 / 20

All tables are natural Clustered based on data ingestion order?

18 / 20

There is a limit of 100 databases that can be replicated per account?

19 / 20

Which of these is not a database object in Snowflake?

20 / 20

Time Travel Syntax can include which of the below?

Your score is

0%