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

Data Shares can only be dropped once approved by a Consumer?

2 / 20

The is a limit of 10 on the number of data shares a consumer can utilise?

3 / 20

Which of below are NOT valid Snowflake Editions?

4 / 20

Which of theses are managed by the Security component of Services Layer?

5 / 20

Which best describes the public Role?

6 / 20

A warehouse can be set to 'autosuspend' if idle for a specified amount of time?

7 / 20

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

8 / 20

Standard Edition provides support for HIPAA, PCI, FedRAMP?

9 / 20

Snowpipe charges for compute while loading files only?

10 / 20

Snowflake Streams hold no data?

11 / 20

What 2 settings control when a query will be killed if queued or running to long?

12 / 20

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

13 / 20

Partner Connect lets you easily create trial accounts with selected Snowflake business partners and integrate these accounts with Snowflake?

14 / 20

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

15 / 20

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

16 / 20

If the Time Travel setting is reduced from 45 to 35 days, all versioned historic time travel data older than 35 days will be deleted

17 / 20

What determines the maximum file size for data unloads out of Snowflake?

18 / 20

Search Optimisation Services can help improve the performance of highly selective lookup queries?

19 / 20

When using a 'Group by' clause try to group on something that has many distinct values?

20 / 20

What are the 2 types of Stage in Snowflake?

Your score is

0%