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 Data type is great for storing semi-structured data?

NUMBER

CHAR

VARCHAR2

VARIANT

2 / 20

Snowflake processes queries using the Storage Layer?

False

True

3 / 20

Columnar data storage benefits from more efficient compression ratio's

True

False

4 / 20

Which of the below options can be used to Improve Query Performance?

Materialized Views

Clustering

Index all columns used in Predicate clause

Search Optimisation

5 / 20

Time Travel is only used to restore a table you can't use it to query a table at a point in the past?

False

True

6 / 20

A multi Cluster warehouse setup may be beneficial for lots of concurrent users and queries?

True

False

7 / 20

What is Snowsight?

Auditing Tool

Privilege usage detector

No such product in Snowflake

New Worksheets replacement

8 / 20

Which file formats are supported for a data unload?

Parquet

XML

Flat i.e. CSV

JSON

9 / 20

A warehouse can be set to 'autosuspend' if idle for a specified amount of time?

True

False

10 / 20

Who are two of the founding members of Snowflake?

Benoit Dageville

Thierry Cruanes

Paul Sammy

Jon Snow

11 / 20

Which of the below are attributes of a secure view?

Executes as owner of role

Special View created for Snowflake support to query data

Definition only visible to authorised users

Bypasses Optimisations

12 / 20

Which of the below are examples of Structured data?

Parquet

AVRO

TSV

CSV

13 / 20

Which of the below describes Data Sharing in Snowflake?

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

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

Data Sharing will duplicate data and increase the storage needed

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

14 / 20

The Snowflake account URL to logon is composed of which of the below?

Region

snowflakecomputing.com

Cloud Provider

Account ID

15 / 20

Time Travel can only be defined and used at the Database level?

False

True

16 / 20

It is for the customer to manage the Snowflake Object Storage used for the database tables by working with the Cloud provider such as AWS?

False

True

17 / 20

A regular expression can be used with the COPY INTO command to filter the file files to target for load?

False

True

18 / 20

COPY INTO Loads are performed as single transaction?

False

True

19 / 20

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

View

Table

User

Schema

20 / 20

What are the 3 layers in the Snowflake architecture?

Services Layer

Compute Layer

Storage Layer

Monitoring Layer

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.