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

Snowpipe charges for compute while loading files only?

True

False

2 / 20

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

10

6

3

1

3 / 20

The Snowflake account URL to logon is composed of which of the below?

Account ID

Cloud Provider

Region

snowflakecomputing.com

4 / 20

Which of the below are examples of unstructured data?

PDF

JSON

Movie

Image

5 / 20

Which of the below are components of ELT?

Load

Transform

Extract

There is not such thing as ELT its should be ETL?

6 / 20

What are the 2 Auto scaling policies?

Economy

Standard

Enterprise

Premium

7 / 20

How many days extra protection does FailSafe provide?

7

14

31

1

8 / 20

Which options below will create a new database called PSAMMY?

CREATE DATABASE PSAMMY COMMENT = 'SNOWDBA Revision';

CREATE DATABASE PSAMMY UNCOMPRESSED STORAGE ONLY;

CREATE DATABASE PSAMMY;

CREATE DATABASE PSAMMY SYSTEM TABLESPACE SYSAUX;

9 / 20

Its possible to kill a running query from the WebUI using 'Abort'

True

False

10 / 20

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

Programmatic Interfaces

Database Engines

AWS

Advanced Analytics

11 / 20

Use of the ORDER BY clause on large datasets can consume vast amounts of Memory and Compute?

False

True

12 / 20

How many extra days does Failsafe provide the ability to restore data from?

31

1

7

30

13 / 20

If a Virtual Warehouse is stopped, we can preserve its cache with the WRITE_CACHE_TO_DISK clause?

True

False

14 / 20

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

False

True

15 / 20

A Encryption Key can be in a state of Retired?

False

True

16 / 20

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

Materialized Views

Clustering

Search Optimisation

Index all columns used in Predicate clause

17 / 20

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

Snowflake Edition being used

File Size

Primary Key Constraints

Number of Files

18 / 20

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

A role with the MANAGE GRANTS privilege can grant privilege

User that created the object can grant privilege

The schema owner can grant privilege

A user with useradmin Role can grant privilege

19 / 20

Time Travel Syntax can include which of the below?

BEFORE

RECOVER

FLASHBACK

AT

20 / 20

What is the purpose of a Network Policy?

Define a new AAA record for Snowflake account

Blocklisting

Allowlisting

Define a new CNAME for Snowflake account

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.