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

The COPY INTO command supports transaction control whereas Snowpipe does not?

True

False

2 / 20

Time Travel is NOT available in Standard Edition?

True

False

3 / 20

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

MAX column ranges

Number of distinct Values

The value of data from the Primary Key

MIN column ranges

4 / 20

When we Unload JSON data which of below are valid File Format Options?

TIME_FORMAT

FILE_EXTENSION

STRIP_NULL_VALUES

PURGE_DUPLICATE

5 / 20

UDF's does not support the use of DDL but do support the use of DML?

False

True

6 / 20

When loading files from a local filesystem using PUT the local host must have which of the below?

Sufficient memory on host

root password available to enter

Sufficient space in /tmp

Windows Admin account password

7 / 20

All data in Snowflake is always protected either at rest or in transit?

True

False

8 / 20

Snowflake customers can save money if they purchase a fixed amount of storage upfront rather than pay on demand?

False

True

9 / 20

A Data Providers is someone who is sharing data?

True

False

10 / 20

How Long does a COPY INTO bulk load retain load history?

8 days

32 days

64 days

16 days

11 / 20

How many minute will the Economy Scaling policy keep queries queued before starting a new Warehouse?

10

3

1

6

12 / 20

A UDF function code will contain $$ only at the end to signify end of code?

True

False

13 / 20

Enabling replication designates the source database as a standby database?

True

False

14 / 20

What are the 2 types of Stage in Snowflake?

Standalone

Clustered

Internal

External

15 / 20

What best defines a Securable Object?

an object protected by an encryption key

an object that can't be dropped

an object which access can be granted

an object that is read only

16 / 20

Standard Edition provides support for HIPAA, PCI, FedRAMP?

False

True

17 / 20

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

select * from table(paulsammy_table_fuction());

select count(*) from my table;

update data to field num1;

select my_udf();

18 / 20

Which of below describes the function of the Metadata Management component in Services Layer?

Used for Time Travel and Cloning

Handles queries that can be processed completely from metadata

Encryption and key Management

Virtual Warehouse resizing policy

19 / 20

Which best describes the accountadmin Role?

A role solely used for useradmin like create user

Role every used needs to access Snowflake

A role solely used to manage grants

Top level role in the system should only granted to 1 or 2 users

20 / 20

Which of the below best describe a File Format ?

The extension used for files unloaded out of Snowflake

Details how to parse files during load/unload

A uninitialized micro partition

The extension used for files loaded into Snowflake

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.