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 are examples of Quasi-Structured data?

2 / 20

Which of the below are components of ELT?

3 / 20

The Cloud Services layer can actually consume billable compute credits?

4 / 20

Discretionary Control is where each Securable Object has many Owners who can't grant others access?

5 / 20

File Encryption in Snowflake can use which of the below algorithms?

6 / 20

Which of the below are examples of Security and governance tools?

7 / 20

Using VALIDATION_MODE option of the COPY INTO command which of the below are valid?

8 / 20

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

9 / 20

Having a high Time Travel setting can help reduce Storage Costs?

10 / 20

An example of Partners that facilitate the loading of data into snowflake are?

11 / 20

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

12 / 20

Which of the below can we perform on data when we LOAD into a table in Snowflake?

13 / 20

Resource Monitors can only be created by account administrators?

14 / 20

Snowflake data is automatically replicated across how many Availability Zones (Data Centres)?

15 / 20

The phase 'Scale Out' with regard to Snowflakes means to add more clusters?

16 / 20

Tasks can not call a Stored Procedure?

17 / 20

How many Accounts can a customer own?

18 / 20

Micro Partitions are created based on ingestion order of data within files to be loaded?

19 / 20

Files uploaded to staging area using PUT are auto encrypted?

20 / 20

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

Your score is

0%