Snowflake Knowledge check Quiz

/20

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 best describes the sysadmin Role?

Pseudo role that is automatically granted to every user

Role dedicated to user and role management only

Top level role in the system

Role privileges to create warehouses and databases

2 / 20

Standard Edition provides support for HIPAA, PCI, FedRAMP?

False

True

3 / 20

Which Editions of Snowflake cover SOC2 Type 2, SOC1 TypeII compliance?

Enterprise

Standard

Virtual Private

Business Critical

4 / 20

External tables provide a flexible way to write and unload data from snowflake?

False

True

5 / 20

Streams are a form of Change Data Capture (CDC)?

False

True

6 / 20

Snowflake data is automatically replicated across how many Availability Zones (Data Centres)?

2

4

3

1

7 / 20

How many Accounts can a customer own?

Unlimited

2

Only 1

Only 1 unless they contact Snowflake Support for more

8 / 20

Static partition pruning is based on columns in the WHERE clause?

False

True

9 / 20

A Stage is used to load or unload data in Snowflake?

False

True

10 / 20

Tasks can't be triggered manually, only on a schedule?

True

False

11 / 20

Which function can assist with reading data from a Variant datatype with nested elements?

FLATTERN()

FATTERN()

UNNEST()

PATTERN()

12 / 20

What command is used to place files on a Stage from a local filesystem?

PLACE

PUT

CP

SCP

13 / 20

Snowflake warehouse credits have a minimum charge of 31 days unless its a leap year then the minimum charge is 28 days, after which daily billing is implemented?

True

False

14 / 20

Data can be loaded as a Join from 2 files into Snowflake?

True

False

15 / 20

All data in Snowflake is always protected either at rest or in transit?

True

False

16 / 20

Which of below are a valid way to see details on views created?

select get_ddl('view','')

show views

desc view

select dbms_metadata.get_ddl('view','')

17 / 20

Which of the below are attributes of a Named Stage?

Can be altered

Can't be dropped

Created manually

Ownership can not be transferred

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

19 / 20

Which of the below are examples of context functions?

sys_context('user','database)

current_account()

current_VPC()

current_user()

20 / 20

Internal Stages are managed by the Customer?

False

True

Your score is

0%

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.

Necessary

Always Enabled

Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.

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.

Others