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 of the below COPY INTO options are related to data length?

2 / 20

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

3 / 20

How many days Time Travel does Standard Edition Provide?

4 / 20

Use of the LIMIT clause can have a large positive impact on performance?

5 / 20

How many minute will the Economy Scaling policy keep queries queued before starting a new Warehouse?

6 / 20

In the WebUI if we select the Account icon on the main ribbon which options do we then see?

7 / 20

Running a virtual warehouse consumes which of the below?

8 / 20

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

9 / 20

A Data Providers is someone who is sharing data?

10 / 20

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

11 / 20

A UDF can return a set of rows (UDFT), but a stored procedure can't?

12 / 20

How often does Snowflake rotate Encryption keys?

13 / 20

Which of the below are true about a TASK in Snowflake?

14 / 20

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

15 / 20

SNOWFLAKE_SAMPLE_DATA is a database share provided for performance testing and learning?

16 / 20

Only a table can be created as transient?

17 / 20

UDF's does not support the use of DDL but do support the use of DML?

18 / 20

A Resource Monitor consists of which of the following properties?

19 / 20

How Long does a Snowpipe retain load history?

20 / 20

Uncorrelated Scalar Subqueries generally run faster than Correlated Scalar Subqueries?

Your score is

0%