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 these is NOT a recognised data workload genre?

Data Engineering

Date Warehouse

Data Science

Data Manipulation Language

Data Lake

Data Science

2 / 20

Which of these is not a database object in Snowflake?

Secure View

Sequence

Type

Table

3 / 20

When transferring a file from local storage using PUT to a Stage, where is the compression performed?

on a virtual warehouse in the services layer

on the local server

on a virtual warehouse in the compute layer

Files can't be compressed with a PUT

4 / 20

Which of the below are examples of a call to a UDTF?

select * from table(paulsammy_table_fuction());

update data to field num1;

select my_udf();

select count(*) from my table;

5 / 20

Which of the below are examples of Technical Partners offerings?

Security & Governance

SQL Editors

Data Integration

Business Intelligence

6 / 20

Which of the below are true of the Optimise Service?

Pruning using metadata and statistics

Automatic Stats gathering

SQL plan baselines and Profiles

Automatic Join order optimisation

7 / 20

Streams identify and act on changed table records?

False

True

8 / 20

A secure view allows access to tables which are owned by the accountadmin role?

True

False

9 / 20

Which of the following does Search Optimisation NOT support?

External tables

Materialized views

Analytical expressions

Permanent Tables

10 / 20

For each securable object, there is a set of privileges that can be granted on it?

True

False

11 / 20

Enabling replication designates the source database as a standby database?

False

True

12 / 20

Tasks can execute multiple DML statements?

False

True

13 / 20

Which of the below are examples of context functions?

current_VPC()

sys_context('user','database)

current_account()

current_user()

14 / 20

Uncorrelated Scalar Subqueries generally run faster than Correlated Scalar Subqueries?

True

False

15 / 20

A Encryption Key can be in a state of Retired?

False

True

16 / 20

Snowpipe requires keypair authentication using JWT?

False

True

17 / 20

Which of the below options can be used to Improve Query Performance?

Index all columns used in Predicate clause

Materialized Views

Search Optimisation

Clustering

18 / 20

What does Tri Secret Secure mean?

Composite master key, customer key and Snowflake maintained key

Snowflake provides and manages 3 separate keys

MFA using 3 separate sources

No such concept

19 / 20

Which of the below are table types in Snowflake?

Index Organised Table

Temporary

Transient

Invisible

20 / 20

User Stages do support file formats?

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.