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

What must we specify when loading a file directly from External Cloud Storage into Snowflake without the use of a stage?

2 / 20

Data Shares can only be dropped once approved by a Consumer?

3 / 20

For each securable object, there is a set of privileges that can be granted on it?

4 / 20

Streams are a form of Change Data Capture (CDC)?

5 / 20

When we Unload JSON data which of below are valid File Format Options?

6 / 20

Discretionary Control is where each Securable Object has many Owners who can't grant others access?

7 / 20

Which of the below are types of Warehouse?

8 / 20

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

9 / 20

Which options do we see on the Classic WebUI Ribbon?

10 / 20

How Long does a COPY INTO bulk load retain load history?

11 / 20

Snowflake has a default file format if none is explicitly set?

12 / 20

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

13 / 20

Snowpipe partially loaded files (based on ON_ERROR) can be combined/split into more transactions?

14 / 20

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

15 / 20

Only Snowflake Support using failsafe can restore an External Table?

16 / 20

Which of these is NOT a recognised data workload genre?

17 / 20

Warehouses assigned to Resource Monitor are suspended and cannot be resumed until which of following?

18 / 20

Which of the below are components of ELT?

19 / 20

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

20 / 20

Which of the below are Scaling Policies for a Warehouse?

Your score is

0%