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

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

2 / 20

Database Replication to Accounts on Lower Editions is possible but only if we use 'IGNORE EDITION CHECK clause' ?

3 / 20

Which of below describes the function of the Metadata Management component in Services Layer?

4 / 20

Zero Copy Cloning allows which of below?

5 / 20

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

6 / 20

Streams identify and act on changed table records?

7 / 20

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

8 / 20

The Results Cache holds 24 hours of results unless data is updated which then invalidates the Cache?

9 / 20

What are the 2 types of Stage in Snowflake?

10 / 20

Which of the options for the COPY INTO command below are related to reloading a file that may have already been loaded?

11 / 20

Stored Procedures can only be written in Python?

12 / 20

Which of the below are attributes of a secure view?

13 / 20

Tasks can't be triggered manually, only on a schedule?

14 / 20

Network Policies can only be assigned at the Account level?

15 / 20

What is Snowsight?

16 / 20

By default Snowflake blacklists all IP Addresses?

17 / 20

Snowflake Data protection features include which of the below?

18 / 20

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

19 / 20

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

20 / 20

We should Organise data being loaded into logical paths like by date, to better aid co-locating that data in the same micro partition?

Your score is

0%