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

How many minute will the Economy Scaling policy keep queries queued before starting a new Warehouse?

10

3

1

6

2 / 20

Which of the below are examples of Quasi-Structured data?

ACRO

XML

JSON

ClickStream

3 / 20

Which of the below describes the Search Optimisation Service?

Users can register one or more tables for Optimisation

Search optimization is a table-level property

Uses a data structure that serves as an optimized search access path

Uses a bitmap index to quickly join unselective data

4 / 20

Which of these is NOT a recognised data workload genre?

Data Manipulation Language

Date Warehouse

Data Lake

Data Science

Data Engineering

5 / 20

Time Travel Syntax can include which of the below?

FLASHBACK

BEFORE

RECOVER

AT

6 / 20

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

False

True

7 / 20

Snowflake has a default file format if none is explicitly set?

True

False

8 / 20

Data Consumers would create an Outbound Share?

False

True

9 / 20

Multi Factor Authentication should be enabled on users with which role?

systemadmin

accountadmin

useradmin

Public

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

11 / 20

A Resource Monitor consists of which of the following properties?

Credit Quota

Monitor Level

A SQL query or Stored Proc to run to monitor the resource usage

Actions

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

False

True

13 / 20

Within a stored procedure argument names are case-insensitive in the JavaScript portion of the stored procedure?

True

False

14 / 20

A temporary table can be restored by contacting Snowflake support who will use failsafe?

True

False

15 / 20

Search Optimisation Services can help improve the performance of highly selective lookup queries?

False

True

16 / 20

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

desc view

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

select get_ddl('view','')

show views

17 / 20

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

False

True

18 / 20

We should Organise data being loaded into logical paths like by date, to better aid co-locating that data in the same micro partition?

True

False

19 / 20

How many Accounts can a customer own?

Only 1

Only 1 unless they contact Snowflake Support for more

2

Unlimited

20 / 20

Which languages can UDF's be written in?

Python

C

JavaScript

SQL

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.