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

Scaling Out a Multi Cluster Warehouse support which options?

3 / 20

When using a 'Group by' clause try to group on something that has many distinct values?

4 / 20

Snowflakes uses table row format to store data in micro partitions?

5 / 20

A Stage is used to load or unload data in Snowflake?

6 / 20

Files hosted on external Cloud Storage can be loaded directly into Snowflake without the use of a Stage?

7 / 20

Which of below are a valid way to see details on views created?

8 / 20

When a database is replicated to another account Snowflake encrypts its database files?

9 / 20

The acronym BI stands for?

10 / 20

Databases created from shares are prime candidates to be Replicated?

11 / 20

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

12 / 20

Using COPY INTO, the FILE FORMAT must be specified unless we have a FILE FORMAT attached to the table or stage?

13 / 20

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

14 / 20

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

15 / 20

Business intelligence (BI) can be described by which of the below?

16 / 20

Which options do we see on the Classic WebUI Ribbon?

17 / 20

Customers can request a “Vanity” Account Logon URL?

18 / 20

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

19 / 20

Running a virtual warehouse consumes which of the below?

20 / 20

Which of these describes a role?

Your score is

0%