Snowflake Knowledge check Quiz

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 Cloud providers provide a 'Private Link' to Snowflake from their Cloud platform?

Oracle

AWS

Alibaba

Azure

2 / 20

Which of the below entities are not part of a Snowflake database?

Schema

View

User

Table

3 / 20

Joining on non unique keys should be encouraged so data output can be as verbose as possible?

True

False

4 / 20

Which of the below best describes Snowflake Architecture?

Shared data

Shared nothing

Data Shares

Shared disk

5 / 20

We can have a maximum of 10 network policies 'active' at one time?

True

False

6 / 20

Partner Connect can be described as technology partners that have joined with Snowflake to create an in-account Snowflake wizard?

False

True

7 / 20

Which of below describes workloads Snowflake can handle best?

OLAP

OLTP

8 / 20

Snowpipe requires keypair authentication using JWT?

True

False

9 / 20

Pipes do not support semi structured data?

True

False

10 / 20

A consumer will use their own Warehouse's compute when accessing a Data Share

True

False

11 / 20

Within a stored procedure argument names are case-insensitive in the JavaScript portion of the stored procedure?

False

True

12 / 20

Small tables are good candidates for a Clustering Key to be defined on?

False

True

13 / 20

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

False

True

14 / 20

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

FORCE

NOPROMPT

LOAD_UNCERTAIN_FILES

FORCE_UNCERTAIN_FILES

15 / 20

Which of the below are attributes of a Named Stage?

Can't be dropped

Can be altered

Ownership can not be transferred

Created manually

16 / 20

What 2 settings control when a query will be killed if queued or running to long?

STATEMENT_TIMEOUT

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

STATEMENT_QUEUED_TIMEOUT

STATEMENT_TIMEOUT_IN_SECONDS

17 / 20

What is the name of feature that allows Snowflake support to restore some types of table after they have been dropped and are outside the TimeTravel retention?

Undo

Failsafe

Flashback

Rollback

18 / 20

Which of the below are examples of a call to a UDTF?

update data to field num1;

select my_udf();

select * from table(paulsammy_table_fuction());

select count(*) from my table;

19 / 20

What commands are used to allow or deny access on an objects to a roles?

REVOKE

DELETE

GRANT

UPDATE

20 / 20

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

TRIM_SPACE

SNAPPY_COMPRESSION

NULL_IF

BINARY_AS_TEXT

Your score is

0%

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.