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 theses are managed by the Security component of Services Layer?

Cost based Optimiser

Encryption and key managment

Access control for shares

Authentication

2 / 20

Which of the below Roles has the privilege to define Network Policies?

AccountAdmin

SecurityAdmin

SysAdmin

Public

3 / 20

Tasks can execute multiple DML statements?

False

True

4 / 20

When a task is created it is initially suspended?

False

True

5 / 20

Which of the below are types of Warehouse?

Multi-Clustered

Always on

Real Application Cluster

Standard

6 / 20

How many days of Query History can be viewed from ribbon item 'History' in the WebUI?

14

7

366

1

7 / 20

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

Task dependencies on other Tasks can be created

Schedule interval set in minutes or a CRON expression

Optionally use with Streams

Schedule SQL execution

8 / 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

9 / 20

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

6

10

3

1

10 / 20

Partner Connect lets you easily create trial accounts with selected Snowflake business partners and integrate these accounts with Snowflake?

False

True

11 / 20

Charges at the Cloud Services layers are for compute that exceeds 10% of total computes costs for the account?

False

True

12 / 20

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

False

True

13 / 20

Which of the below are examples of Technical Partners offerings?

SQL Editors

Business Intelligence

Security & Governance

Data Integration

14 / 20

Which of these is not a database object in Snowflake?

Sequence

Secure View

Type

Table

15 / 20

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

True

False

16 / 20

You can use SQL ID as the basis to set the time that Time Travel will use?

False

True

17 / 20

Which of the below are Valid Snowflake Editions?

Virtual Private

Express

Enterprise

Business Focused

18 / 20

What are the 2 default INBOUND shares of every account?

SNOWFLAKE_SAMPLE_DATA

SNOWFLAKE

There are no default inbound shares

SNOWFLAKE_DATA

19 / 20

Which of these describes a role?

Object which is assigned to users

A special privilege to raise Snowflake support tickets

Object which privileges are granted

A super user that has access to everything

20 / 20

Which of the below are types of Stage in Snowflake?

Named Stage

User Stage

Custom Stage

Table Stage

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.