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

Scaling Out a Multi Cluster Warehouse support which options?

2 / 20

The Cloud Services layer can actually consume billable compute credits?

3 / 20

The best way to choose the right Warehouse size is to?

4 / 20

Where can we upload data from in Snowflake?

5 / 20

Which of the below can we perform on data when we LOAD into a table in Snowflake?

6 / 20

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

7 / 20

Which of the below are examples of Quasi-Structured data?

8 / 20

Which of the below best describes Snowflake Architecture?

9 / 20

Internal Stages are managed by the Customer?

10 / 20

The acronym BI stands for?

11 / 20

Pipes contains a 'COPY INTO' statement?

12 / 20

Which Port is used for General SnowFlake traffic?

13 / 20

A UDF can return a set of rows (UDFT), but a stored procedure can't?

14 / 20

Files hosted on external Cloud Storage can be loaded directly into Snowflake without the use of a Stage?

15 / 20

We should look to process one large file rather than splitting a large files into smaller ones before loading into Snowflake so each warehouse can parallel process the file?

16 / 20

Which of the following does Search Optimisation NOT support?

17 / 20

Once data changes are made to a Zero Copy Clone database, new micro partitions will track that change?

18 / 20

A temporary Table can be created as Global and shared with other sessions?

19 / 20

What must we specify when loading a file directly from External Cloud Storage into Snowflake without the use of a stage?

20 / 20

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

Your score is

0%