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

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

2 / 20

Which of below could describe Machine Learning & Data Science?

3 / 20

Database shares can be read write?

4 / 20

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

5 / 20

Which of the below are types of Stage in Snowflake?

6 / 20

A Warehouse can only be resized if it is idle and suspended?

7 / 20

Which of the following does Search Optimisation NOT support?

8 / 20

Which best describes the sysadmin Role?

9 / 20

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

10 / 20

Snowpipe partially loaded files (based on ON_ERROR) can be combined/split into more transactions?

11 / 20

Which of these is not a database object in Snowflake?

12 / 20

Resource Monitor notifications are sent to all Account Administrators?

13 / 20

Which of the below best describe a File Format ?

14 / 20

'WAREHOUSE_METERING_HISTORY' view shows how much cloud service compute an account has used?

15 / 20

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

16 / 20

The Cloud Services layer can actually consume billable compute credits?

17 / 20

Tasks can not call a Stored Procedure?

18 / 20

Users must manually refresh a Materialised View to keep it's data upto date?

19 / 20

We should look to process one large file rather than splitting a large files into smaller ones before loading into Snowflake so each warehouse can parallel process the file?

20 / 20

Which cloud provider Supports the most Regions in Snowflake?

Your score is

0%