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

Which options below will create a new database called PSAMMY?

2 / 20

Pipes load data into tables continuously from an ingestion queue?

3 / 20

Which of the below are examples of a call to a UDTF?

4 / 20

Which of the below is an example of a Solution Partners services?

5 / 20

Data Consumers would create an Outbound Share?

6 / 20

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

7 / 20

What best defines a Securable Object?

8 / 20

Time Travel is NOT available in Standard Edition?

9 / 20

If the same query is re-run with no change in underlying data by a different user then the cached results from the previous query run are sent to that user so no Compute is used?

10 / 20

In the WebUI if we select the Account icon on the main ribbon which options do we then see?

11 / 20

When loading files from a local filesystem using PUT the local host must have which of the below?

12 / 20

When using a 'Group by' clause try to group on something that has many distinct values?

13 / 20

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

14 / 20

Which of the below COPY INTO options are related to data length?

15 / 20

Only Standard Views can be created as secure?

16 / 20

Databases created from shares are prime candidates to be Replicated?

17 / 20

Which of the below are examples of context functions?

18 / 20

Which file formats are supported for a data unload?

19 / 20

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

20 / 20

User Stages do support file formats?

Your score is

0%