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 are valid services managed by the Service Layer?

 

2 / 20

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

3 / 20

Time Travel can only be defined and used at the Database level?

4 / 20

Most trial accounts start with 3 letters followed by 10  numbers?

5 / 20

Snowflake Multi Factor Authentication makes use of DUO?

6 / 20

Snowflake Data protection features include which of the below?

7 / 20

A UDF can return a singular scalar value OR if defined a UDTF can return a set of rows?

8 / 20

An example of a Resource Manager action could be  suspending a Virtual Warehouse?

9 / 20

How many minute will the Economy Scaling policy keep queries queued before starting a new Warehouse?

10 / 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?

11 / 20

The COPY INTO command supports transaction control whereas Snowpipe does not?

12 / 20

Who are two of the founding members of Snowflake?

13 / 20

If the Time Travel setting is reduced from 45 to 35 days, all versioned historic time travel data older than 35 days will be deleted

14 / 20

How many days Time Travel does Standard Edition Provide?

15 / 20

Storage is billed as uncompressed data?

16 / 20

Which best describes the public Role?

17 / 20

How many days of Query History can be viewed from ribbon item 'History' in the WebUI?

18 / 20

What are the 2 types of Stage in Snowflake?

19 / 20

Using Snowpipe does not require a customer started virtual warehouse?

20 / 20

What are the 2 methods for checking a PIPE and getting records into a table?

Your score is

0%