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

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

2 / 20

Users must manually refresh a Materialised View to keep it's data upto date?

3 / 20

The SNOWFLAKE database contains information about account usage?

4 / 20

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

5 / 20

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

6 / 20

Which of the below are true of the Optimise Service?

7 / 20

The COPY INTO command can specify a maximum list of 1000 files to load at a time?

8 / 20

How many days maximum do Editions of Snowflake higher than STANDARD allow time travel to be set for

9 / 20

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

10 / 20

Which of the below are components of ELT?

11 / 20

Shared Data is always upto date?

12 / 20

Only Enterprise Edition and above can create a Data Share?

13 / 20

Wild card predicate using

LIKE '%string%'

will encourage partition pruning?

14 / 20

Data Encryption uses a Hierarchical key model?

15 / 20

Partner Connect can be described as technology partners that have joined with Snowflake to create an in-account Snowflake wizard?

16 / 20

Which of the below describes the Search Optimisation Service?

17 / 20

A larger type Warehouse size may be needed for?

18 / 20

Which role does a standard view execute as ?

19 / 20

There is a limit of 100 databases that can be replicated per account?

20 / 20

What is Snowsight?

Your score is

0%