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

File Encryption in Snowflake can use which of the below algorithms?

2 / 20

A UDF function code will contain $$ only at the end to signify end of code?

3 / 20

COPY INTO Loads are performed as single transaction?

4 / 20

Which Cloud providers provide a 'Private Link' to Snowflake from their Cloud platform?

5 / 20

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

6 / 20

How many days maximum do Editions of Snowflake higher than STANDARD allow time travel to be set for

7 / 20

A Database can hold many Schema's?

8 / 20

The best way to choose the right Warehouse size is to?

9 / 20

What is the maximum size of each micro partition (compressed data)?

10 / 20

The Time Travel feature allows customers to restore there data back to ANY time in the past since the database was created?

11 / 20

Which of the below are components of ELT?

12 / 20

Data Encryption uses a Hierarchical key model?

13 / 20

Which Port is used for General SnowFlake traffic?

14 / 20

Wild card predicate using

LIKE '%string%'

will encourage partition pruning?

15 / 20

Which role does a standard view execute as ?

16 / 20

What best defines a Securable Object?

17 / 20

Data Consumers would create an Outbound Share?

18 / 20

It is better to share an entire table rather than a Secure View?

19 / 20

Which of the below are Scaling Policies for a Warehouse?

20 / 20

Search Optimisation Services can help improve the performance of highly selective lookup queries?

Your score is

0%