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 Encryption uses a Hierarchical key model?

2 / 20

In Snowflake all communication is encrypted using TLS1.2?

3 / 20

Which of below Function can operate on Semi-Structured data?

4 / 20

Stored Procedures can only be written in Python?

5 / 20

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

6 / 20

Which of the below are examples of Structured data?

7 / 20

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

8 / 20

Every active user session has a current role?

9 / 20

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

10 / 20

What is the a name of the account type created by the provider and used by a consumer to access a Share using the providers compute?

11 / 20

Its possible to kill a running query from the WebUI using 'Abort'

12 / 20

When Resource Monitoring limits are approached an action can be triggered?

13 / 20

Which of the below is an example of a Solution Partners services?

14 / 20

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

15 / 20

Tasks can execute multiple DML statements?

16 / 20

Uncorrelated Scalar Subqueries generally run faster than Correlated Scalar Subqueries?

17 / 20

External tables provide a flexible way to write and unload data from snowflake?

18 / 20

Which of the below could we use to describe a Stream?

19 / 20

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

20 / 20

The Metadata Cache could contain data upto 60 minutes Stale?

Your score is

0%