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 are true about a TASK in Snowflake?

2 / 20

Which of the below are examples of offerings Technical Partners provide?

3 / 20

Wild card predicate using

LIKE '%string%'

will encourage partition pruning?

4 / 20

Most trial accounts start with 3 letters followed by 10  numbers?

5 / 20

A regular expression can be used with the COPY INTO command to filter the file files to target for load?

6 / 20

A warehouse using Auto suspend and Resume can be expensive in credit consumption and should be avoided to save costs?

7 / 20

A Resource Monitor consists of which of the following properties?

8 / 20

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

9 / 20

Snowflake Multi Factor Authentication makes use of DUO?

10 / 20

Use of the LIMIT clause can have a large positive impact on performance?

11 / 20

Snowflake uses natural clustering to co-locate similar column value data ranges?

12 / 20

Which of the below are attributes of a secure view?

13 / 20

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

14 / 20

Using Resource Monitoring can help with Which of the below?

15 / 20

UDF code contains $$ to signify this could double the compute power costs to run the code?

16 / 20

Snowflake Streams hold no data?

17 / 20

Using VALIDATION_MODE option of the COPY INTO command which of the below are valid?

18 / 20

The Snowflake account URL to logon is composed of which of the below?

19 / 20

How many Accounts can a customer own?

20 / 20

Which of the below could we use to describe a Stream?

Your score is

0%