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 regular expression can be used with the COPY INTO command to filter the file files to target for load?

2 / 20

What format does Snowflake store its data?

3 / 20

It is better to share an entire table rather than a Secure View?

4 / 20

SNOWFLAKE_SAMPLE_DATA is a database share provided for performance testing and learning?

5 / 20

Time Travel Syntax can include which of the below?

6 / 20

A Warehouse can only be resized if it is idle and suspended?

7 / 20

Which of the below best describe a File Format ?

8 / 20

When a task is created it is initially suspended?

9 / 20

A transient table will be dropped when the user session that created it ends?

10 / 20

What is Snowsight?

11 / 20

Dynamic partition pruning is based on the JOIN columns of a query?

12 / 20

What are the 2 types of Stage in Snowflake?

13 / 20

In the WebUI if we select the Account icon on the main ribbon which options do we then see?

14 / 20

We use the 'COPY INTO' clause to ingest files into a table?

15 / 20

Which Port is used for General SnowFlake traffic?

16 / 20

Tasks can't be triggered manually, only on a schedule?

17 / 20

We can use CIDR notation to specify a subnet range for a whitelisted network policy?

18 / 20

The SNOWFLAKE Account Usage Share contains information about a users account like query history?

19 / 20

Shared Data is always upto date?

20 / 20

Each increase in Warehouse size i.e. from Small to Medium or Medium to larges uses a Snowflake internal logarithmic algorithm to determine the number of clusters to add?

Your score is

0%