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

Why would we CAST data from a Variant?

2 / 20

Uncorrelated Scalar Subqueries generally run faster than Correlated Scalar Subqueries?

3 / 20

Table Stages are created automatically by the system?

4 / 20

It is for the customer to manage the Snowflake Object Storage used for the database tables by working with the Cloud provider such as AWS?

5 / 20

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

6 / 20

Which of the below are Valid Snowflake Editions?

7 / 20

In Snowflake all communication is encrypted using TLS1.2?

8 / 20

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

9 / 20

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

10 / 20

A Materialised View will actually store the result set on disk separate from the underlying table data it queries?

11 / 20

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

12 / 20

Data Encryption uses a Hierarchical key model?

13 / 20

Which Cloud providers provide a 'Private Link' to Snowflake from their Cloud platform?

14 / 20

Which options do we see on the Classic WebUI Ribbon?

15 / 20

Natural table Clustering can not be overridden?

16 / 20

Databases created from shares are prime candidates to be Replicated?

17 / 20

Which of below are a valid way to see details on views created?

18 / 20

What does Tri Secret Secure mean?

19 / 20

Using the context CURRENT_ACCOUNT() could be used to restrict data in a secure view?

20 / 20

The Snowflake account URL to logon is composed of which of the below?

Your score is

0%