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

Internal Stages are managed by the Customer?

2 / 20

Users must manually refresh a Materialised View to keep it's data upto date?

3 / 20

What are the 2 methods for checking a PIPE and getting records into a table?

4 / 20

Only Enterprise Edition and above can create a Data Share?

5 / 20

Time Travel can only be defined and used at the Database level?

6 / 20

There is a limit of 100 databases that can be replicated per account?

7 / 20

Most trial accounts start with 3 letters followed by 10  numbers?

8 / 20

Which of the below is the smallest Size Warehouse that can be configured?

9 / 20

Who are two of the founding members of Snowflake?

10 / 20

A secure view allows access to tables which are owned by the accountadmin role?

11 / 20

Snowflake data is automatically replicated across how many Availability Zones (Data Centres)?

12 / 20

Which of the below are components of ELT?

13 / 20

A Data Providers is someone who is sharing data?

14 / 20

Customers must define a maintenance window for which Snowflake can use to allow downtime needed to apply patch updates?

15 / 20

Which of below describes the function of the Metadata Management component in Services Layer?

16 / 20

Which of the below are true of the Optimise Service?

17 / 20

Which of the below is an example of a Solution Partners services?

18 / 20

Which of below describes workloads Snowflake can handle best?

19 / 20

Semi-Structured data has support for all SQL operations?

20 / 20

Data Consumers would create an Outbound Share?

Your score is

0%