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

Tasks can't be triggered manually, only on a schedule?

2 / 20

Which best describes the sysadmin Role?

3 / 20

Which pipes are cloned with Zero Copy Cloning?

4 / 20

The phase 'Scale Out' with regard to Snowflakes means to add more clusters?

5 / 20

Which of the below are examples of Quasi-Structured data?

6 / 20

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

7 / 20

Having a high Time Travel setting can help reduce Storage Costs?

8 / 20

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

9 / 20

Which of the below are true of the Optimise Service?

10 / 20

Zero Copy Cloning allows which of below?

11 / 20

The Metadata Cache could contain data upto 60 minutes Stale?

12 / 20

Encryption Keys are automatically rotated every 30 days?

13 / 20

Which of below describes workloads Snowflake can handle best?

14 / 20

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

15 / 20

Which Port is used for General SnowFlake traffic?

16 / 20

The phase 'Scale Up' with regard to Snowflakes means to increase the cluster size i.e. from Small to Medium

17 / 20

Only Standard Views can be created as secure?

18 / 20

Only a table can be created as transient?

19 / 20

Wild card predicate using

LIKE '%string%'

will encourage partition pruning?

20 / 20

Internal Stages can be in different regions and use a different Cloud Provider to that which the Snowflake Account resides in?

Your score is

0%