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 of the below are examples of Quasi-Structured data?

2 / 20

Federated Authentication is not possible in Snowflake?

3 / 20

What determines the maximum file size for data unloads out of Snowflake?

4 / 20

There is no limit on the number of Data Shares a Provider can provision?

5 / 20

When Loading files 'from' Cloud Storage we must use the PUT Command

6 / 20

A warehouse using Auto suspend and Resume can be expensive in credit consumption and should be avoided to save costs?

7 / 20

Which best describes the accountadmin Role?

8 / 20

Using Snowpipe we can scale compute for different workloads manually whereas COPY INTO uses a serverless compute model which we have no control?

9 / 20

User Stages do support file formats?

10 / 20

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

11 / 20

What are the 3 layers in the Snowflake architecture?

12 / 20

Which of these describes a role?

13 / 20

Storage is billed as uncompressed data?

14 / 20

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

15 / 20

Pipes load data into tables continuously from an ingestion queue?

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

17 / 20

When we Unload data which of below are valid Parquet file format options?

18 / 20

Which of the below best describes Snowflake Architecture?

19 / 20

Pipes do not support semi structured data?

20 / 20

Streams identify and act on changed table records?

Your score is

0%