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

Files uploaded to staging area using PUT are auto encrypted?

2 / 20

Use of the ORDER BY clause on large datasets can consume vast amounts of Memory and Compute?

3 / 20

For a warehouse if MAX Clusters = 1 then we have a scale out Multi-Cluster setup?

4 / 20

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

5 / 20

Every new database created contains 2 schemas what are these called?

6 / 20

Where can we upload data from in Snowflake?

7 / 20

What is the purpose of a Network Policy?

8 / 20

SNOWFLAKE_SAMPLE_DATA is a database share provided for performance testing and learning?

9 / 20

Which of below could describe Machine Learning & Data Science?

10 / 20

Scaling Out a Multi Cluster Warehouse support which options?

11 / 20

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

12 / 20

If a Virtual Warehouse is stopped, we can preserve its cache with the WRITE_CACHE_TO_DISK clause?

13 / 20

Shared Data is always upto date?

14 / 20

Which of the below are types of Stage in Snowflake?

15 / 20

Time Travel is only used to restore a table you can't use it to query a table at a point in the past?

16 / 20

Tasks can not call a Stored Procedure?

17 / 20

Internal Stages are managed by the Customer?

18 / 20

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

19 / 20

What does Tri Secret Secure mean?

20 / 20

Which of the below Cloud Storage offering are supported by Snowflake?

Your score is

0%