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

Snowpipe requires keypair authentication using JWT?

2 / 20

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

3 / 20

Semi-Structured data has support for all SQL operations?

4 / 20

What is the purpose of a Network Policy?

5 / 20

Snowflake Multi Factor Authentication makes use of DUO?

6 / 20

We can have a maximum of 10 network policies 'active' at one time?

7 / 20

How Long does a Snowpipe retain load history?

8 / 20

Tasks can not call a Stored Procedure?

9 / 20

Time Travel is only used to restore a table you can't use it to query a table at a point in the past?

10 / 20

Only a table can be created as transient?

11 / 20

Which of the below best describe a File Format ?

12 / 20

A Stored Procedure can only run as the owner and not the caller?

13 / 20

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

14 / 20

Using COPY INTO, the FILE FORMAT must be specified unless we have a FILE FORMAT attached to the table or stage?

15 / 20

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

16 / 20

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

17 / 20

Which edition of Snowflake is HIPPA Support and PCI Compliance introduced?

18 / 20

Zero Copy Cloning allows which of below?

19 / 20

What are the 3 layers in the Snowflake architecture?

20 / 20

Which of the below are examples of Semi-Structured data?

Your score is

0%