Created by The Snowman

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

Stored Procedures can only be written in Javascript?

2 / 20

Snowflake Streams hold no data?

3 / 20

The Cloud Services layer can actually consume billable compute credits?

4 / 20

During a Data Unload which option can we specify so data is not split into separate files?

5 / 20

What command is used to place files on a Stage from a local filesystem?

6 / 20

Which of the below options of the COPY INTO command can be used with ON_ERROR?

7 / 20

What are the 2 default INBOUND shares of every account?

8 / 20

What are the 2 types of Stage in Snowflake?

9 / 20

Time Travel Syntax can include which of the below?

10 / 20

Which of the below best describe a File Format ?

11 / 20

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

12 / 20

The is a limit of 10 on the number of data shares a consumer can utilise?

13 / 20

Within a stored procedure argument names are case-insensitive in the JavaScript portion of the stored procedure?

14 / 20

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

15 / 20

Which function can assist with reading data from a Variant datatype with nested elements?

16 / 20

Which file formats are supported for a data unload?

17 / 20

We should look to process one large file rather than splitting a large files into smaller ones before loading into Snowflake so each warehouse can parallel process the file?

18 / 20

We should Organise data being loaded into logical paths like by date, to better aid co-locating that data in the same micro partition?

19 / 20

Defining a Clustering Key can override natural clustering on a table?

20 / 20

Which Data type is great for storing semi-structured data?

Your score is