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

Databases created from shares are prime candidates to be Replicated?

2 / 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?

3 / 20

Which of the below Roles has the privilege to define Network Policies?

4 / 20

Which of the below are examples of unstructured data?

5 / 20

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

6 / 20

Using Snowpipe does not require a customer started virtual warehouse?

7 / 20

Running a virtual warehouse consumes which of the below?

8 / 20

UDF code contains $$ to signify this could double the compute power costs to run the code?

9 / 20

How many Accounts can a customer own?

10 / 20

An example of a Resource Manager action could be  suspending a Virtual Warehouse?

11 / 20

Which of the below options of the COPY INTO command can be used with ON_ERROR?

12 / 20

If we define a Clustering Key Snowflakes keeps the clustering order updated in background and the user is charged for this service?

13 / 20

What icon will a secure view have by it side in the WebUI?

14 / 20

All tables are natural Clustered based on data ingestion order?

15 / 20

What format does Snowflake store its data?

16 / 20

For a warehouse if MAX Clusters = 1 then we have a scale out Multi-Cluster setup?

17 / 20

What are the 3 layers in the Snowflake architecture?

18 / 20

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

19 / 20

We can have a maximum of 10 network policies 'active' at one time?

20 / 20

What is the maximum size of each micro partition (compressed data)?

Your score is

0%