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 below entities are not part of a Snowflake database?

2 / 20

The COPY INTO command supports transaction control whereas Snowpipe does not?

3 / 20

Only Snowflake Support using failsafe can restore an External Table?

4 / 20

Which of below describes workloads Snowflake can handle best?

5 / 20

The transform part of ETL can be best described as 'modifying source data using conversion methods' ?

6 / 20

Resource Monitors can only be created by account administrators?

7 / 20

Multi Factor Authentication should be enabled on users with which role?

8 / 20

Data Encryption uses a Hierarchical key model?

9 / 20

Which of the below are examples of Technical Partners offerings?

10 / 20

What are the 2 default INBOUND shares of every account?

11 / 20

By default Snowflake blacklists all IP Addresses?

12 / 20

Using the context CURRENT_ACCOUNT() could be used to restrict data in a secure view?

13 / 20

Internal Stages are managed by the Customer?

14 / 20

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

15 / 20

Wild card predicate using

LIKE '%string%'

will encourage partition pruning?

16 / 20

A Materialised View will actually store the result set on disk separate from the underlying table data it queries?

17 / 20

Using Resource Monitoring can help with Which of the below?

18 / 20

You can use SQL ID as the basis to set the time that Time Travel will use?

19 / 20

Who are two of the founding members of Snowflake?

20 / 20

Zero Copy Cloning allows which of below?

Your score is

0%