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

Time Travel is only used to restore a table you can't use it to query a table at a point in the past?

2 / 20

Time Travel Syntax can include which of the below?

3 / 20

Which of the below options can be used to Improve Query Performance?

4 / 20

Using COPY INTO, the FILE FORMAT must be specified unless we have a FILE FORMAT attached to the table or stage?

5 / 20

Resource Monitors can only be created by account administrators?

6 / 20

Failsafe supports all table types as long as the customer is running on Enterprise Edition or above?

7 / 20

The Service Layer stores which of the below about each Micro Partition?

8 / 20

Snowflake processes queries using the Storage Layer?

9 / 20

Which of the below is the smallest Size Warehouse that can be configured?

10 / 20

All tables are natural Clustered based on data ingestion order?

11 / 20

Data Shares can only be dropped once approved by a Consumer?

12 / 20

COPY INTO Loads are performed as single transaction?

13 / 20

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

14 / 20

A Data Providers is someone who is sharing data?

15 / 20

How many days extra protection does FailSafe provide?

16 / 20

Shared Data is always upto date?

17 / 20

How many days Time Travel does Standard Edition Provide?

18 / 20

Which best describes the accountadmin Role?

19 / 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

20 / 20

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

Your score is

0%