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 of the below could we use to describe a Stream?

Identify and act on changed table records

STREAMS are consumed using DML

Stores a timestamp offset like a bookmark

Can only have one stream on a table

2 / 20

Using Resource Monitoring can help with Which of the below?

Set Limits for a specified interval

Control how much CPU of a warehouse user consumes

Help control costs and avoid unexpected credit usage

Impose limits on the number of credits that are consumed

3 / 20

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

True

False

4 / 20

External Stages are managed by the Customer?

False

True

5 / 20

Zero Copy Cloning allows which of below?

No such concept

Copy Numeric data from a table if it contains a zero

Clone user accounts

Take a Snapshot or of any table, schema or database

6 / 20

The Results Cache holds 24 hours of results unless data is updated which then invalidates the Cache?

False

True

7 / 20

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

cage

shield

padlock

none its shown the same as a standard view

8 / 20

Which of the below best describe a File Format ?

The extension used for files unloaded out of Snowflake

The extension used for files loaded into Snowflake

Details how to parse files during load/unload

A uninitialized micro partition

9 / 20

Which of the below are table types in Snowflake?

Temporary

Invisible

Transient

Index Organised Table

10 / 20

Which pipes are cloned with Zero Copy Cloning?

pipes that reference an external stage

pipes that reference an internal stage

11 / 20

Files hosted on external Cloud Storage can be loaded directly into Snowflake without the use of a Stage?

False

True

12 / 20

How many days extra protection does FailSafe provide?

31

7

14

1

13 / 20

Which of the below describes Data Sharing in Snowflake?

A large database shared could have a huge impact on Storage costs

Data Sharing will duplicate data and increase the storage needed

A large database shared will have a no impact on Storage costs

Data Sharing will not duplicate data , so no impact on the storage needed

14 / 20

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

False

True

15 / 20

The best way to choose the right Warehouse size is to?

Submit a statspack report to Snowflake Support to advise

Monitor warehouse load on each Warehouse

Experiment running the same query on different Warehouses

Start with the largest possible warehouse and see if that is ok after a week

16 / 20

Database shares can be read write?

False

True

17 / 20

Which best describes the public Role?

Top-level role in the system

Role dedicated to user and role management only

Pseudo role that is automatically granted to every user

Role privileges to create warehouses and databases

18 / 20

Stored procedures allow the execution of both DDL and DML?

False

True

19 / 20

There is a limit of 100 databases that can be replicated per account?

True

False

20 / 20

A Materialised View will actually store the result set on disk separate from the underlying table data it queries?

True

False

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.