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

Database Replication to Accounts on Lower Editions is possible but only if we use 'IGNORE EDITION CHECK clause' ?

2 / 20

In a Network policy if we Whitelist something then everything else is automatically blacklisted?

3 / 20

An example of a Resource Manager action could be  suspending a Virtual Warehouse?

4 / 20

The acronym BI stands for?

5 / 20

Running a virtual warehouse consumes which of the below?

6 / 20

A warehouse using Auto suspend and Resume can be expensive in credit consumption and should be avoided to save costs?

7 / 20

What are the types of Caching available in Snowflake?

8 / 20

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

9 / 20

Static partition pruning is based on columns in the WHERE clause?

10 / 20

How many days extra protection does FailSafe provide?

11 / 20

Use of the LIMIT clause can have a large positive impact on performance?

12 / 20

Pipes do not support semi structured data?

13 / 20

Which of the below are examples of Semi-Structured data?

14 / 20

How Long does a Snowpipe retain load history?

15 / 20

Which of these Cloud Providers does Snowflake support?

16 / 20

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

17 / 20

We can have a maximum of 10 network policies 'active' at one time?

18 / 20

Which best describes the sysadmin Role?

19 / 20

Which of the below are examples of Security and governance tools?

20 / 20

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

Your score is

0%