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

Which of the below best describe a File Format ?

2 / 20

Which best describes the sysadmin Role?

3 / 20

A Resource Monitor consists of which of the following properties?

4 / 20

Which pipes are cloned with Zero Copy Cloning?

5 / 20

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

6 / 20

Time Travel Syntax can include which of the below?

7 / 20

A transient table will be dropped when the user session that created it ends?

8 / 20

Which role does a standard view execute as ?

9 / 20

Once a database is created, we can not transfer ownership of that database to another Role without recreating it?

10 / 20

Which of these is not a database object in Snowflake?

11 / 20

When loading data from files into SnowFlake what 2 main factors may impact performance of that load?

12 / 20

Standard Edition provides support for HIPAA, PCI, FedRAMP?

13 / 20

What is the maximum size of each micro partition (compressed data)?

14 / 20

Only a table has a encryption key not a micro partition?

15 / 20

Storage is billed as uncompressed data?

16 / 20

Network Policies can only be assigned at the Account level?

17 / 20

The SNOWFLAKE Account Usage Share contains information about a users account like query history?

18 / 20

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

19 / 20

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

20 / 20

Partner Connect lets you easily create trial accounts with selected Snowflake business partners and integrate these accounts with Snowflake?

Your score is

0%