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 options do we see on the Classic WebUI Ribbon?

2 / 20

Stored Procedures can only be written in Javascript?

3 / 20

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

4 / 20

Snowpipe loads are combined or split into multiple transactions based on number/size of rows per datafile?

5 / 20

Which role does a standard view execute as ?

6 / 20

Which role will add the 'Account' icon on the Classic WebUI ribbon?

7 / 20

The best way to choose the right Warehouse size is to?

8 / 20

What are the 2 types of Stage in Snowflake?

9 / 20

Encryption Keys are automatically rotated every 30 days?

10 / 20

Which of the following does Search Optimisation NOT support?

11 / 20

Only the Snowflake Support can perform data restores using  FailSafe?

12 / 20

When transferring a file from local storage using PUT to a Stage, where is the compression performed?

13 / 20

The bigger a Warehouse the larger the cache that Warehouse has to use?

14 / 20

Files uploaded to staging area using PUT are auto encrypted?

15 / 20

Tasks can not call a Stored Procedure?

16 / 20

Which of the below are table types in Snowflake?

17 / 20

There is no limit on the number of Data Shares a Provider can provision?

18 / 20

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

19 / 20

Which of the below could we use to describe a Stream?

20 / 20

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

Your score is

0%