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

Secure Views and UDFs, bypass optimisations to protect data?

2 / 20

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

3 / 20

Only Enterprise Edition and above can create a Data Share?

4 / 20

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

5 / 20

Database Replication to Accounts on Lower Editions is possible but only if we use 'IGNORE EDITION CHECK clause' ?

6 / 20

Pipes do not support semi structured data?

7 / 20

Which of these describes a role?

8 / 20

Snowpipe charges for compute while loading files only?

9 / 20

User Stages do support file formats?

10 / 20

The Time Travel feature allows customers to restore there data back to ANY time in the past since the database was created?

11 / 20

Columnar data storage benefits from more efficient compression ratio's

12 / 20

What command is used to place files on a Stage from a local filesystem?

13 / 20

Which of the below are components of ELT?

14 / 20

The Service Layer stores which of the below about each Micro Partition?

15 / 20

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

16 / 20

Using VALIDATION_MODE option of the COPY INTO command which of the below are valid?

17 / 20

How Long does a Snowpipe retain load history?

18 / 20

Only a table has a encryption key not a micro partition?

19 / 20

The Time Travel feature is only available in Enterprise Edition or above?

20 / 20

Which of the below best describes Snowflake Architecture?

Your score is

0%