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

When a database is replicated to another account Snowflake encrypts its database files?

True

False

2 / 20

Using Snowpipe does not require a customer started virtual warehouse?

True

False

3 / 20

Snowflake uses natural clustering to co-locate similar column value data ranges?

True

False

4 / 20

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

Sometimes overlaps with technologies such Advanced Analytics.

Technology behind Time Travel and FailSafe

Deliver data visualization through dashboards

Enable analyzing, discovering, and reporting on data

5 / 20

For a warehouse if MAX Clusters = 1 then we have a scale out Multi-Cluster setup?

False

True

6 / 20

When loading files from a local filesystem using PUT the local host must have which of the below?

root password available to enter

Sufficient space in /tmp

Sufficient memory on host

Windows Admin account password

7 / 20

Resource Monitors can only be created by account administrators?

False

True

8 / 20

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

False

True

9 / 20

Warehouses assigned to Resource Monitor are suspended and cannot be resumed until which of following?

The next interval

The monitor is dropped

The credit quota for the monitor is increased

Ownership of Warehouse is transferred to acountadmin role

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

11 / 20

The Metadata Cache could contain data upto 60 minutes Stale?

True

False

12 / 20

What icon will a secure view have by it side in the WebUI?

padlock

none its shown the same as a standard view

cage

shield

13 / 20

Every new database created contains 2 schemas what are these called?

INFORMATION_SCHEMA

METADATA_SCHEMA

PRIVATE

PUBLIC

14 / 20

When loading data from files into SnowFlake what 2 main factors may impact performance of that load?

Snowflake Edition being used

Primary Key Constraints

Number of Files

File Size

15 / 20

An example of a Resource Manager action could be suspending a Virtual Warehouse?

True

False

16 / 20

Data Encryption uses a Hierarchical key model?

False

True

17 / 20

What 2 settings control when a query will be killed if queued or running to long?

STATEMENT_QUEUED_TIMEOUT

STATEMENT_TIMEOUT_IN_SECONDS

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

STATEMENT_TIMEOUT

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

Select only Account

zero copy compute Account

Reader Account

No such concept in Snowflake

19 / 20

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

True

False

20 / 20

Which best describes the public Role?

Role dedicated to user and role management only

Pseudo role that is automatically granted to every user

Role privileges to create warehouses and databases

Top-level role in the system

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.