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 role will add the 'Account' icon on the Classic WebUI ribbon?

2 / 20

Which of the below is an example of a Solution Partners services?

3 / 20

How many days Time Travel does Standard Edition Provide?

4 / 20

Which of these describes a role?

5 / 20

A multi Cluster warehouse setup may be beneficial for lots of concurrent users and queries?

6 / 20

Snowflake processes queries using the Storage Layer?

7 / 20

There is a limit of 100 databases that can be replicated per account?

8 / 20

Snowflake data is automatically replicated across how many Availability Zones (Data Centres)?

9 / 20

What is the a name of the account type created by the provider and used by a consumer to access a Share using the providers compute?

10 / 20

The best way to choose the right Warehouse size is to?

11 / 20

Which options below will create a new database called PSAMMY?

12 / 20

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

13 / 20

Using Snowpipe does not require a customer started virtual warehouse?

14 / 20

Which of the below entities are not part of a Snowflake database?

15 / 20

The COPY INTO command can specify a maximum list of 1000 files to load at a time?

16 / 20

Which of the below are true of the Optimise Service?

17 / 20

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

18 / 20

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

19 / 20

Data can be loaded as a Join from 2 files into Snowflake?

20 / 20

In Snowflake all communication is encrypted using TLS1.2?

Your score is

0%