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

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

2 / 20

Tasks can not call a Stored Procedure?

3 / 20

How many days 'maximum' does Time Travel Enterprise Edition and above provide as a limit?

4 / 20

Which of the below are true of the Optimise Service?

5 / 20

Only a table has a encryption key not a micro partition?

6 / 20

Which Data type is great for storing semi-structured data?

7 / 20

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

8 / 20

Which of the below are requirements or restrictions for a User Password in Snowflake?

9 / 20

Which of the below best describe a File Format ?

10 / 20

When we Unload data which of below are valid Parquet file format options?

11 / 20

Once a database is created, we can not transfer ownership of that database to another Role without recreating it?

12 / 20

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

13 / 20

A Resource Monitor consists of which of the following properties?

14 / 20

How many extra days does Failsafe provide the ability to restore data from?

15 / 20

Joining on non unique keys should be encouraged so data output can be as verbose as possible?

16 / 20

Which of the below describes the Search Optimisation Service?

17 / 20

Tasks can execute multiple DML statements?

18 / 20

A Stored Procedure 'may' return a value but a UDF 'must' return a value?

19 / 20

In a Network policy if we Whitelist something then everything else is automatically blacklisted?

20 / 20

It is possible to Validate data to be loaded with out actually loading the data with the COPY INTO command

Your score is

0%