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

External Stages are managed by the Customer?

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

3 / 20

Which of below are NOT valid Snowflake Editions?

4 / 20

Encryption Key Rotation will cause downtime so must be done during the users Maintenance Window?

5 / 20

Snowflake has a grant that allows all 'Future' objects created in a schema to be granted privileges to a role Automatically?

6 / 20

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

7 / 20

How Long does a Snowpipe retain load history?

8 / 20

Pipes do not support semi structured data?

9 / 20

Shared Data is always upto date?

10 / 20

Files uploaded to staging area using PUT are auto encrypted?

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

12 / 20

The Snowflake account URL to logon is composed of which of the below?

13 / 20

When using a 'Group by' clause try to group on something that has many distinct values?

14 / 20

Which of the below are components of ELT?

15 / 20

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

16 / 20

Multi Factor Authentication should be enabled on users with which role?

17 / 20

UDF code contains $$ to signify this could double the compute power costs to run the code?

18 / 20

Which of the below is an example of a Solution Partners services?

19 / 20

Snowflakes uses table row format to store data in micro partitions?

20 / 20

Only Enterprise Edition and above can create a Data Share?

Your score is

0%