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

The Metadata Cache could contain data upto 60 minutes Stale?

False

True

2 / 20

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

Files can't be compressed with a PUT

on a virtual warehouse in the compute layer

on the local server

on a virtual warehouse in the services layer

3 / 20

A Stage is used to load or unload data in Snowflake?

True

False

4 / 20

What are the 2 types of Stage in Snowflake?

Clustered

External

Internal

Standalone

5 / 20

Which of the below are examples of Security and governance tools?

Risk Assessment

Data Masking

SQL Optimisation

Intrusion Monitoring

6 / 20

Having a high Time Travel setting can help reduce Storage Costs?

False

True

7 / 20

What are the 2 Auto scaling policies?

Enterprise

Premium

Standard

Economy

8 / 20

How Long does a COPY INTO bulk load retain load history?

8 days

16 days

32 days

64 days

9 / 20

The best way to choose the right Warehouse size is to?

Start with the largest possible warehouse and see if that is ok after a week

Experiment running the same query on different Warehouses

Monitor warehouse load on each Warehouse

Submit a statspack report to Snowflake Support to advise

10 / 20

What is the name of feature that allows Snowflake support to restore some types of table after they have been dropped and are outside the TimeTravel retention?

Rollback

Flashback

Undo

Failsafe

11 / 20

Database Replication to Accounts on Lower Editions is possible but only if we use 'IGNORE EDITION CHECK clause' ?

True

False

12 / 20

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

False

True

13 / 20

Which function can assist with reading data from a Variant datatype with nested elements?

FATTERN()

PATTERN()

FLATTERN()

UNNEST()

14 / 20

The transform part of ETL can be best described as 'modifying source data using conversion methods' ?

True

False

15 / 20

Which of the below Roles has the privilege to define Network Policies?

SysAdmin

AccountAdmin

Public

SecurityAdmin

16 / 20

How many days Time Travel does Standard Edition Provide?

7

30

1

0

17 / 20

External Stages are managed by the Customer?

True

False

18 / 20

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

True

False

19 / 20

A temporary Table can be created as Global and shared with other sessions?

False

True

20 / 20

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

update data to field num1;

select my_udf();

select * from table(paulsammy_table_fuction());

select count(*) from my table;

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.