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

Failsafe supports all table types as long as the customer is running on Enterprise Edition or above?

2 / 20

Which of the below are types of Warehouse?

3 / 20

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

4 / 20

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

5 / 20

How many extra days does Failsafe provide the ability to restore data from?

6 / 20

Data can be loaded as a Join from 2 files into Snowflake?

7 / 20

Automatic table Clustering can be Suspended and Resumed?

8 / 20

Micro Partitions are immutable, what does this mean?

9 / 20

The Metadata Cache could contain data upto 60 minutes Stale?

10 / 20

What type of Cloud Platform is Snowflake?

11 / 20

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

12 / 20

Discretionary Control is where each Securable Object has many Owners who can't grant others access?

13 / 20

Which role does a standard view execute as ?

14 / 20

Which of the below are components of ELT?

15 / 20

During data Unload we cannot use a SQL query to target the data to extract?

16 / 20

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

17 / 20

When a database is replicated to another account Snowflake encrypts its database files?

18 / 20

The SNOWFLAKE Account Usage Share contains information about a users account like query history?

19 / 20

Which cloud provider Supports the most Regions in Snowflake?

20 / 20

Which of the below are attributes of a Named Stage?

Your score is

0%