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

Small tables are good candidates for a Clustering Key to be defined on?

False

True

2 / 20

Which of the below best describes Snowflake Architecture?

Shared data

Data Shares

Shared disk

Shared nothing

3 / 20

Which of the below are examples of context functions?

current_user()

current_account()

sys_context('user','database)

current_VPC()

4 / 20

Which of the below is an example of a Solution Partners services?

helping to tune your premise database

Assisting with design, preparation, re-platforming

Assisting with performance optimization

Helping you migrate or implement Snowflake

5 / 20

Standard Edition provides support for HIPAA, PCI, FedRAMP?

True

False

6 / 20

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

Task dependencies on other Tasks can be created

Schedule SQL execution

Optionally use with Streams

Schedule interval set in minutes or a CRON expression

7 / 20

What are the 2 types of Stage in Snowflake?

Internal

External

Clustered

Standalone

8 / 20

Data Consumers would create an Outbound Share?

True

False

9 / 20

The SNOWFLAKE Account Usage Share contains information about a users account like query history?

False

True

10 / 20

Which of the below are examples of offerings Technical Partners provide?

Advanced Analytics

Database Engines

Programmatic Interfaces

AWS

11 / 20

Which languages can UDF's be written in?

C

JavaScript

Python

SQL

12 / 20

In a 'managed access' schema, what would allow the granting of a object privilege within that schema?

User that created the object can grant privilege

A role with the MANAGE GRANTS privilege can grant privilege

The schema owner can grant privilege

A user with useradmin Role can grant privilege

13 / 20

Discretionary Control is where each Securable Object has many Owners who can't grant others access?

True

False

14 / 20

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

VARIANT

NUMBER

CHAR

VARCHAR2

15 / 20

A Database can hold many Schema's?

True

False

16 / 20

Storage is billed as uncompressed data?

False

True

17 / 20

Zero Copy Cloning allows which of below?

Clone user accounts

No such concept

Copy Numeric data from a table if it contains a zero

Take a Snapshot or of any table, schema or database

18 / 20

During data Unload we cannot use a SQL query to target the data to extract?

False

True

19 / 20

Secure Views and UDFs, bypass optimisations to protect data?

False

True

20 / 20

Database Replication can be enabled for any existing permanent or transient database?

True

False

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.