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

Shared Data is always upto date?

2 / 20

Standard Edition provides support for HIPAA, PCI, FedRAMP?

3 / 20

How many Accounts can a customer own?

4 / 20

External Stages are managed by the Customer?

5 / 20

The phase 'Scale Up' with regard to Snowflakes means to increase the cluster size i.e. from Small to Medium

6 / 20

A Database can hold many Schema's?

7 / 20

Micro Partitions are created based on ingestion order of data within files to be loaded?

8 / 20

All data in Snowflake is always protected either at rest or in transit?

9 / 20

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

10 / 20

Federated Authentication is not possible in Snowflake?

11 / 20

A UDF function code will contain $$ only at the end to signify end of code?

12 / 20

Which of below describes workloads Snowflake can handle best?

13 / 20

Small tables are good candidates for a Clustering Key to be defined on?

14 / 20

It is possible to Validate data to be loaded with out actually loading the data with the COPY INTO command

15 / 20

Customers can request a “Vanity” Account Logon URL?

16 / 20

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

17 / 20

The bigger a Warehouse the larger the cache that Warehouse has to use?

18 / 20

The Cloud Services layer can actually consume billable compute credits?

19 / 20

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

20 / 20

Wild card predicate using

LIKE '%string%'

will encourage partition pruning?

Your score is

0%