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

Resource Monitors can only be created by account administrators?

2 / 20

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

3 / 20

Snowflake Data protection features include which of the below?

4 / 20

The phase 'Scale Up' with regard to Snowflakes means to increase the cluster size i.e. from Small to Medium

5 / 20

Which of below Function can operate on Semi-Structured data?

6 / 20

Which of these is not a database object in Snowflake?

7 / 20

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

8 / 20

Which of theses are managed by the Security component of Services Layer?

9 / 20

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

10 / 20

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

11 / 20

We should always use ORDER BY clause in a subquery for the implicit performance gains?

12 / 20

Snowflake customers can save money if they purchase a fixed amount of storage upfront rather than pay on demand?

13 / 20

Which of the below are default System defined roles in Snowflake?

14 / 20

Secure Views and UDFs, bypass optimisations to protect data?

15 / 20

By default Snowflake blacklists all IP Addresses?

16 / 20

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

17 / 20

An example of Partners that facilitate the loading of data into snowflake are?

18 / 20

Every active user session has a current role?

19 / 20

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

20 / 20

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

Your score is

0%