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 following does Search Optimisation NOT support?

2 / 20

Micro Partitions are immutable, what does this mean?

3 / 20

The Results Cache holds 24 hours of results unless data is updated which then invalidates the Cache?

4 / 20

Which of the below Roles has the privilege to define Network Policies?

5 / 20

How often does Snowflake rotate Encryption keys?

6 / 20

Which of the below are components of ELT?

7 / 20

When loading data from files into SnowFlake what 2 main factors may impact performance of that load?

8 / 20

Snowpipe charges for compute while loading files only?

9 / 20

When Loading files 'from' Cloud Storage we must use the PUT Command

10 / 20

Once data changes are made to a Zero Copy Clone database, new micro partitions will track that change?

11 / 20

Tasks can't be triggered manually, only on a schedule?

12 / 20

Which of the below are types of Warehouse?

13 / 20

Wild card predicate using

LIKE '%string%'

will encourage partition pruning?

14 / 20

What is the name of feature that allows Snowflake support to restore some types of table after they have been dropped and are outside the TimeTravel retention?

15 / 20

A Stage is used to load or unload data in Snowflake?

16 / 20

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

17 / 20

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

18 / 20

Snowflake has a default file format if none is explicitly set?

19 / 20

Which of the below Cloud Storage offering are supported by Snowflake?

20 / 20

Database Replication is only supported across the Same Cloud provider i.e. AWS to AWS as the source but to a different or the same region?

Your score is

0%