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

A Stage is used to load or unload data in Snowflake?

2 / 20

All tables are natural Clustered based on data ingestion order?

3 / 20

What are the 2 default INBOUND shares of every account?

4 / 20

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

5 / 20

Time Travel Syntax can include which of the below?

6 / 20

Only a table has a encryption key not a micro partition?

7 / 20

Micro Partitions are immutable, what does this mean?

8 / 20

Which of the below are true about a TASK in Snowflake?

9 / 20

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

10 / 20

What determines the maximum file size for data unloads out of Snowflake?

11 / 20

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

12 / 20

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

13 / 20

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

14 / 20

What does Tri Secret Secure mean?

15 / 20

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

16 / 20

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

17 / 20

Use of the ORDER BY clause on large datasets can consume vast amounts of Memory and Compute?

18 / 20

A warehouse can be set to 'autosuspend' if idle for a specified amount of time?

19 / 20

All data in Snowflake is always protected either at rest or in transit?

20 / 20

Which of the below are Scaling Policies for a Warehouse?

Your score is

0%