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

Failsafe supports all table types as long as the customer is running on Enterprise Edition or above?

2 / 20

You can use SQL ID as the basis to set the time that Time Travel will use?

3 / 20

Each virtual warehouse is an independent compute cluster but it shares resources with 'other' virtual warehouses?

4 / 20

Which of below describes workloads Snowflake can handle best?

5 / 20

Internal Stages are managed by the Customer?

6 / 20

What are the 2 Auto scaling policies?

7 / 20

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

8 / 20

Only a table can be created as transient?

9 / 20

Uncorrelated Scalar Subqueries generally run faster than Correlated Scalar Subqueries?

10 / 20

Enabling replication designates the source database as a standby database?

11 / 20

What type of Cloud Platform is Snowflake?

12 / 20

Snowflake uses natural clustering to co-locate similar column value data ranges?

13 / 20

We can use CIDR notation to specify a subnet range for a whitelisted network policy?

14 / 20

A Resource Monitor consists of which of the following properties?

15 / 20

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

16 / 20

Which of the below are examples of Technical Partners offerings?

17 / 20

How Long does a COPY INTO bulk load retain load history?

18 / 20

Which of the below best describe a File Format ?

19 / 20

Database Replication to Accounts on Lower Editions is possible but only if we use 'IGNORE EDITION CHECK clause' ?

20 / 20

Which of below are NOT valid Snowflake Editions?

Your score is

0%