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

In the WebUI if we select the Account icon on the main ribbon which options do we then see?

Resource Monitors

Usage

Performance Recommendations

Billing

2 / 20

A warehouse can be set to 'autosuspend' if idle for a specified amount of time?

True

False

3 / 20

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

SQL Optimisation

Data Masking

Intrusion Monitoring

Risk Assessment

4 / 20

Every active user session has a current role?

False

True

5 / 20

Which of the below describes Data Sharing in Snowflake?

Data Sharing will not duplicate data , so no impact on the storage needed

A large database shared could have a huge impact on Storage costs

A large database shared will have a no impact on Storage costs

Data Sharing will duplicate data and increase the storage needed

6 / 20

Semi-Structured data has support for all SQL operations?

False

True

7 / 20

Which of the following does Search Optimisation NOT support?

Materialized views

Analytical expressions

External tables

Permanent Tables

8 / 20

How many days 'maximum' does Time Travel Enterprise Edition and above provide as a limit?

120

30

60

90

9 / 20

Snowflake Streams hold no data?

True

False

10 / 20

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

False

True

11 / 20

Warehouses assigned to Resource Monitor are suspended and cannot be resumed until which of following?

Ownership of Warehouse is transferred to acountadmin role

The credit quota for the monitor is increased

The monitor is dropped

The next interval

12 / 20

Snowpipe loads are combined or split into multiple transactions based on number/size of rows per datafile?

False

True

13 / 20

Which of below Function can operate on Semi-Structured data?

ARRAY_AGG

SEMI_STRUCT_DECODE

PARSE_JSON

FLATTERN

14 / 20

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

True

False

15 / 20

Which of the below are Scaling Policies for a Warehouse?

Buy One Get one Free

Standard

Economy

Organic

16 / 20

Customers must define a maintenance window for which Snowflake can use to allow downtime needed to apply patch updates?

True

False

17 / 20

What best defines a Securable Object?

an object which access can be granted

an object protected by an encryption key

an object that is read only

an object that can't be dropped

18 / 20

Which file formats are supported for a data unload?

Flat i.e. CSV

JSON

Parquet

XML

19 / 20

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

True

False

20 / 20

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

update data to field num1;

select my_udf();

select count(*) from my table;

select * from table(paulsammy_table_fuction());

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.