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

How many days 'maximum' does Time Travel Enterprise Edition and above provide as a limit?

2 / 20

Which of the below are valid COPY INTO options?

3 / 20

Internal Stages are managed by the Customer?

4 / 20

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

5 / 20

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

6 / 20

Files hosted on external Cloud Storage can be loaded directly into Snowflake without the use of a Stage?

7 / 20

A Stored Procedure 'may' return a value but a UDF 'must' return a value?

8 / 20

What is the name of feature that allows Snowflake support to restore some types of table after they have been dropped and are outside the TimeTravel retention?

9 / 20

Streams are a form of Change Data Capture (CDC)?

10 / 20

Which of the below are examples of a call to a UDTF?

11 / 20

Data can be loaded as a Join from 2 files into Snowflake?

12 / 20

A temporary table can be restored by contacting Snowflake support who will use failsafe?

13 / 20

Having a high Time Travel setting can help reduce Storage Costs?

14 / 20

Partner Connect lets you easily create trial accounts with selected Snowflake business partners and integrate these accounts with Snowflake?

15 / 20

Which options do we see on the Classic WebUI Ribbon?

16 / 20

The Cloud Services layer can actually consume billable compute credits?

17 / 20

Which of the below best describe a File Format ?

18 / 20

Which of the following Semi Structured formats does Snowflake support?

19 / 20

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

20 / 20

Where can we upload data from in Snowflake?

Your score is

0%