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

Zero Copy Cloning allows which of below?

Copy Numeric data from a table if it contains a zero

No such concept

Clone user accounts

Take a Snapshot or of any table, schema or database

2 / 20

Which of these is NOT a recognised data workload genre?

Data Science

Data Engineering

Data Science

Data Manipulation Language

Data Lake

Date Warehouse

3 / 20

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

True

False

4 / 20

Partner Connect can be described as technology partners that have joined with Snowflake to create an in-account Snowflake wizard?

False

True

5 / 20

Which best describes the securityadmin Role?

Pseudo role that is automatically granted to every user

Role that can manage any object grant globally

Role privileges to create warehouses and databases

Top level role in the system

6 / 20

Pipes do not support semi structured data?

False

True

7 / 20

Running a virtual warehouse consumes which of the below?

Buckets

Tokens

Bitcoin

Credits

8 / 20

Databases created from shares are prime candidates to be Replicated?

False

True

9 / 20

A consumer will use their own Warehouse's compute when accessing a Data Share

False

True

10 / 20

A UDF can return a set of rows (UDFT), but a stored procedure can't?

True

False

11 / 20

Database Replication is only supported across the Same Cloud provider i.e. AWS to AWS as the source but to a different or the same region?

True

False

12 / 20

Use of the LIMIT clause can have a large positive impact on performance?

False

True

13 / 20

A larger type Warehouse size may be needed for?

lots of concurrent users

Processing very large datasets

Lots of Data shares used by Consumers

Complex SQL queries and analytics

14 / 20

Using Snowpipe does not require a customer started virtual warehouse?

True

False

15 / 20

What are the types of View available in Snowflake?

Secure View

Materialized View

Standard View

Partition Merge View

16 / 20

Automatic table Clustering can be Suspended and Resumed?

False

True

17 / 20

Which of below describes the function of the Metadata Management component in Services Layer?

Used for Time Travel and Cloning

Encryption and key Management

Virtual Warehouse resizing policy

Handles queries that can be processed completely from metadata

18 / 20

Time Travel can only be defined and used at the Database level?

False

True

19 / 20

UDF's does not support the use of DDL but do support the use of DML?

False

True

20 / 20

Only Enterprise Edition and above can create a Data Share?

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.