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 are valid services managed by the Service Layer?

Access control

Metadata Management

Manages Sessions

Authentication

2 / 20

Which of below could describe Machine Learning & Data Science?

statistical and predictive modelling

artificial intelligence

advanced analytics

Big Data

3 / 20

Database shares can be read write?

True

False

4 / 20

Which of the below are Scaling Policies for a Warehouse?

Economy

Standard

Organic

Buy One Get one Free

5 / 20

The bigger a Warehouse the larger the cache that Warehouse has to use?

False

True

6 / 20

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

False

True

7 / 20

Which of the below are examples of Quasi-Structured data?

ACRO

ClickStream

XML

JSON

8 / 20

What are the 2 default INBOUND shares of every account?

SNOWFLAKE

There are no default inbound shares

SNOWFLAKE_SAMPLE_DATA

SNOWFLAKE_DATA

9 / 20

Pipes load data into tables continuously from an ingestion queue?

True

False

10 / 20

Multi Factor Authentication can be used with which of the below?

sqlplus

SnowSQL

WebUI

Python Connector

11 / 20

The Time Travel feature is only available in Enterprise Edition or above?

True

False

12 / 20

Which of the below describes Data Sharing in Snowflake?

A large database shared will have a no 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

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

13 / 20

All tables are natural Clustered based on data ingestion order?

False

True

14 / 20

Which of the below best describes Snowflake Architecture?

Shared data

Shared nothing

Data Shares

Shared disk

15 / 20

Why would we CAST data from a Variant?

To format output of a query

To mask data output

It is not possible to Cast data from a Variant

To compare Variant with other types of data it must be CAST

16 / 20

Data Consumers would create an Outbound Share?

True

False

17 / 20

Semi-Structured data has support for all SQL operations?

False

True

18 / 20

Which role will add the 'Account' icon on the Classic WebUI ribbon?

no such option on the WebUI ribbon

sysadmin

accountadmin

systemadmin

19 / 20

When a task is created it is initially suspended?

False

True

20 / 20

Business intelligence (BI) can be described by which of the below?

Sometimes overlaps with technologies such Advanced Analytics.

Enable analyzing, discovering, and reporting on data

Technology behind Time Travel and FailSafe

Deliver data visualization through dashboards

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.