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 entities are not part of a Snowflake database?

2 / 20

During data Unload we cannot use a SQL query to target the data to extract?

3 / 20

When we Unload data which of below are valid Parquet file format options?

4 / 20

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

5 / 20

Which of the below are table types in Snowflake?

6 / 20

Time Travel is NOT available in Standard Edition?

7 / 20

What does Tri Secret Secure mean?

8 / 20

A UDF can return a set of rows (UDFT), but a stored procedure can't?

9 / 20

Uncorrelated Scalar Subqueries generally run faster than Correlated Scalar Subqueries?

10 / 20

How many extra days does Failsafe provide the ability to restore data from?

11 / 20

Table Stages are created automatically by the system?

12 / 20

We should look to process one large file rather than splitting a large files into smaller ones before loading into Snowflake so each warehouse can parallel process the file?

13 / 20

Automatic table Clustering can be Suspended and Resumed?

14 / 20

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

15 / 20

Which of the below Roles has the privilege to define Network Policies?

16 / 20

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

17 / 20

Which best describes the public Role?

18 / 20

It is better to share an entire table rather than a Secure View?

19 / 20

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

20 / 20

A Database can hold many Schema's?

Your score is

0%