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

What is the a name of the account type created by the provider and used by a consumer to access a Share using the providers compute?

2 / 20

Standard Edition provides support for HIPAA, PCI, FedRAMP?

3 / 20

Only a table can be created as transient?

4 / 20

How many days Time Travel does Standard Edition Provide?

5 / 20

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

6 / 20

Which best describes the useradmin Role?

7 / 20

Which of the below are valid COPY INTO options?

8 / 20

DATA_RETENTION_TIME_IN_SECONDS is used to define the Time Travel duration?

9 / 20

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

10 / 20

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

11 / 20

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

12 / 20

A Data Providers is someone who is sharing data?

13 / 20

What is the maximum size of each micro partition (compressed data)?

14 / 20

Which of the below is the smallest Size Warehouse that can be configured?

15 / 20

Which of these is not a database object in Snowflake?

16 / 20

Which of the below describes the Search Optimisation Service?

17 / 20

It is better to share an entire table rather than a Secure View?

18 / 20

Stored Procedures can only be written in Python?

19 / 20

When transferring a file from local storage using PUT to a Stage, where is the compression performed?

20 / 20

A Stored Procedure 'may' return a value but a UDF 'must' return a value?

Your score is

0%