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

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

2 / 20

Which best describes the public Role?

3 / 20

The COPY INTO command supports transaction control whereas Snowpipe does not?

4 / 20

The phase 'Scale Out' with regard to Snowflakes means to add more clusters?

5 / 20

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

6 / 20

Which function can assist with reading data from a Variant datatype with nested elements?

7 / 20

Which options do we see on the Classic WebUI Ribbon?

8 / 20

A Materialised View will actually store the result set on disk separate from the underlying table data it queries?

9 / 20

Which of the below are examples of Technical Partners offerings?

10 / 20

Which of below describes workloads Snowflake can handle best?

11 / 20

Which of below could describe Machine Learning & Data Science?

12 / 20

In a Network policy if we Whitelist something then everything else is automatically blacklisted?

13 / 20

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

14 / 20

Wild card predicate using

LIKE '%string%'

will encourage partition pruning?

15 / 20

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

16 / 20

An example of Partners that facilitate the loading of data into snowflake are?

17 / 20

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

18 / 20

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

19 / 20

Which best describes the accountadmin Role?

20 / 20

What are the 2 default INBOUND shares of every account?

Your score is

0%