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 options can be used to Improve Query Performance?

2 / 20

User Stages do support file formats?

3 / 20

The Time Travel feature is only available in Enterprise Edition or above?

4 / 20

What format does Snowflake store its data?

5 / 20

Which of the options for the COPY INTO command below are related to reloading a file that may have already been loaded?

6 / 20

Only Snowflake Support using failsafe can restore an External Table?

7 / 20

Trial accounts can be converted to paid accounts?

8 / 20

The transform part of ETL can be best described as 'modifying source data using conversion methods' ?

9 / 20

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

10 / 20

What are the 2 types of Stage in Snowflake?

11 / 20

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

12 / 20

Internal Stages are managed by the Customer?

13 / 20

There is no limit on the number of Data Shares a Provider can provision?

14 / 20

Snowflake has a default file format if none is explicitly set?

15 / 20

Only Standard Views can be created as secure?

16 / 20

Its possible to kill a running query from the WebUI using 'Abort'

17 / 20

Which pipes are cloned with Zero Copy Cloning?

18 / 20

Which cloud provider Supports the most Regions in Snowflake?

19 / 20

The Results Cache holds 24 hours of results unless data is updated which then invalidates the Cache?

20 / 20

If the same query is re-run with no change in underlying data by a different user then the cached results from the previous query run are sent to that user so no Compute is used?

Your score is

0%