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

An example of a Resource Manager action could be  suspending a Virtual Warehouse?

3 / 20

Defining a Clustering Key can override natural clustering on a table?

4 / 20

During a Data Unload which option can we specify so data is not split into separate files?

5 / 20

The transform part of ETL can be best described as 'modifying source data using conversion methods' ?

6 / 20

How many days extra protection does FailSafe provide?

7 / 20

Multi Factor Authentication can be used with which of the below?

8 / 20

Use of the ORDER BY clause on large datasets can consume vast amounts of Memory and Compute?

9 / 20

Which cloud provider Supports the most Regions in Snowflake?

10 / 20

Which of the below describes the Search Optimisation Service?

11 / 20

Streams identify and act on changed table records?

12 / 20

What are the 2 Auto scaling policies?

13 / 20

A temporary Table can be created as Global and shared with other sessions?

14 / 20

Which best describes the sysadmin Role?

15 / 20

What commands are used to allow or deny access on an objects to a roles?

16 / 20

What are the 2 default INBOUND shares of every account?

17 / 20

Dynamic partition pruning is based on the JOIN columns of a query?

18 / 20

Semi-Structured data has support for all SQL operations?

19 / 20

Tasks can not call a Stored Procedure?

20 / 20

A transient table will be dropped when the user session that created it ends?

Your score is

0%