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

Only the Snowflake Support can perform data restores using  FailSafe?

2 / 20

How many days Time Travel does Standard Edition Provide?

3 / 20

You can use SQL ID as the basis to set the time that Time Travel will use?

4 / 20

Which of the below are components of ELT?

5 / 20

Which of below describes the function of the Metadata Management component in Services Layer?

6 / 20

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

7 / 20

Snowflake data is automatically replicated across how many Availability Zones (Data Centres)?

8 / 20

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

9 / 20

Which of the below are examples of Technical Partners offerings?

10 / 20

Resource Monitors can only be created by account administrators?

11 / 20

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

12 / 20

Snowpipe loads are combined or split into multiple transactions based on number/size of rows per datafile?

13 / 20

Running a virtual warehouse consumes which of the below?

14 / 20

The Metadata Cache could contain data upto 60 minutes Stale?

15 / 20

Which of the below are examples of Structured data?

16 / 20

If a Virtual Warehouse is stopped, we can preserve its cache with the WRITE_CACHE_TO_DISK clause?

17 / 20

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

18 / 20

Once a database is created, we can not transfer ownership of that database to another Role without recreating it?

19 / 20

Streams identify and act on changed table records?

20 / 20

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

Your score is

0%