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

When Resource Monitoring limits are approached an action can be triggered?

2 / 20

Which pipes are cloned with Zero Copy Cloning?

3 / 20

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

4 / 20

A permanent table can have Time travel of upto 1 year?

5 / 20

Running a virtual warehouse consumes which of the below?

6 / 20

Search Optimisation Services can help improve the performance of highly selective lookup queries?

7 / 20

Which of below could describe Machine Learning & Data Science?

8 / 20

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

9 / 20

Multi Factor Authentication should be enabled on users with which role?

10 / 20

Using Snowpipe we can scale compute for different workloads manually whereas COPY INTO uses a serverless compute model which we have no control?

11 / 20

What commands are used to allow or deny access on an objects to a roles?

12 / 20

The is a limit of 10 on the number of data shares a consumer can utilise?

13 / 20

Dynamic partition pruning is based on the JOIN columns of a query?

14 / 20

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

15 / 20

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

16 / 20

Every active user session has a current role?

17 / 20

Failsafe supports all table types as long as the customer is running on Enterprise Edition or above?

18 / 20

Stored Procedures can only be written in Javascript?

19 / 20

Only Standard Views can be created as secure?

20 / 20

Which Port is used for General SnowFlake traffic?

Your score is

0%