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

When a task is created it is initially suspended?

2 / 20

Snowflake has a default file format if none is explicitly set?

3 / 20

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

4 / 20

A permanent table can have Time travel of upto 1 year?

5 / 20

A Data Providers is someone who is sharing data?

6 / 20

Data Encryption uses a Hierarchical key model?

7 / 20

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

8 / 20

We can have a maximum of 10 network policies 'active' at one time?

9 / 20

Which of below are valid Authentication methods in Snowflake?

10 / 20

What is Snowsight?

11 / 20

What are the types of View available in Snowflake?

12 / 20

Databases created from shares are prime candidates to be Replicated?

13 / 20

Database Replication to Accounts on Lower Editions is possible but only if we use 'IGNORE EDITION CHECK clause' ?

14 / 20

What are the 2 Auto scaling policies?

15 / 20

Once data changes are made to a Zero Copy Clone database, new micro partitions will track that change?

16 / 20

In a  'managed access' schema, what would allow the granting of a object privilege within that schema?

17 / 20

Data Consumers would create an Outbound Share?

18 / 20

The Metadata Cache could contain data upto 60 minutes Stale?

19 / 20

Columnar data storage benefits from more efficient compression ratio's

20 / 20

During a Data Unload which option can we specify so data is not split into separate files?

Your score is

0%