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

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

True

False

2 / 20

Which of the below are attributes of a secure view?

Special View created for Snowflake support to query data

Bypasses Optimisations

Executes as owner of role

Definition only visible to authorised users

3 / 20

Which Data type is great for storing semi-structured data?

VARCHAR2

VARIANT

CHAR

NUMBER

4 / 20

A Data Providers is someone who is sharing data?

False

True

5 / 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?

zero copy compute Account

Select only Account

Reader Account

No such concept in Snowflake

6 / 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?

Failsafe

Rollback

Undo

Flashback

7 / 20

Stored procedures allow the execution of both DDL and DML?

False

True

8 / 20

The COPY INTO command can specify a maximum list of 1000 files to load at a time?

False

True

9 / 20

Internal Stages are managed by the Customer?

False

True

10 / 20

Uncorrelated Scalar Subqueries generally run faster than Correlated Scalar Subqueries?

True

False

11 / 20

A temporary table can be restored by contacting Snowflake support who will use failsafe?

True

False

12 / 20

Which Port is used for General SnowFlake traffic?

8080

1521

22

443

13 / 20

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

The value of data from the Primary Key

MIN column ranges

MAX column ranges

Number of distinct Values

14 / 20

A permanent table can have Time travel of upto 1 year?

False

True

15 / 20

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

False

True

16 / 20

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

False

True

17 / 20

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

Files can't be compressed with a PUT

on a virtual warehouse in the compute layer

on a virtual warehouse in the services layer

on the local server

18 / 20

Which of the below best describes Snowflake Architecture?

Shared nothing

Shared disk

Shared data

Data Shares

19 / 20

Which of the below are examples of Structured data?

TSV

Parquet

CSV

AVRO

20 / 20

Which of the below are true about a TASK in Snowflake?

Schedule SQL execution

Optionally use with Streams

Task dependencies on other Tasks can be created

Schedule interval set in minutes or a CRON expression

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.