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 below Function can operate on Semi-Structured data?

2 / 20

Using Resource Monitoring can help with Which of the below?

3 / 20

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

4 / 20

A warehouse can be set to 'autosuspend' if idle for a specified amount of time?

5 / 20

What determines the maximum file size for data unloads out of Snowflake?

6 / 20

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

7 / 20

Stored Procedures can only be written in Javascript?

8 / 20

Only the Snowflake Support can perform data restores using  FailSafe?

9 / 20

Which of the following does Search Optimisation NOT support?

10 / 20

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

11 / 20

Partner Connect can be described as technology partners that have joined with Snowflake to create an in-account Snowflake wizard?

12 / 20

Within a stored procedure argument names are case-insensitive in the JavaScript portion of the stored procedure?

13 / 20

Which of these Cloud Providers does Snowflake support?

14 / 20

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

15 / 20

A permanent table can have Time travel of upto 1 year?

16 / 20

Each increase in Warehouse size i.e. from Small to Medium or Medium to larges uses a Snowflake internal logarithmic algorithm to determine the number of clusters to add?

17 / 20

Network Policies can only be assigned at the Account level?

18 / 20

There is no limit on the number of Data Shares a Provider can provision?

19 / 20

What is Snowsight?

20 / 20

What are the 2 Auto scaling policies?

Your score is

0%