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

Snowflake data is automatically replicated across how many Availability Zones (Data Centres)?

1

2

3

4

2 / 20

The COPY INTO command can specify a maximum list of 1000 files to load at a time?

True

False

3 / 20

Which of below could describe Machine Learning & Data Science?

statistical and predictive modelling

Big Data

artificial intelligence

advanced analytics

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

True

False

5 / 20

How many days Time Travel does Standard Edition Provide?

7

30

0

1

6 / 20

Stored Procedures can only be written in Javascript?

False

True

7 / 20

UDF code contains $$ to signify this could double the compute power costs to run the code?

False

True

8 / 20

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

PARSE_JSON

FLATTERN

ARRAY_AGG

SEMI_STRUCT_DECODE

9 / 20

During data Unload we cannot use a SQL query to target the data to extract?

False

True

10 / 20

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

True

False

11 / 20

Time Travel is NOT available in Standard Edition?

False

True

12 / 20

A regular expression can be used with the COPY INTO command to filter the file files to target for load?

True

False

13 / 20

Which of the below system Roles by default can create a Data Share?

sysdba

accountadmin

dbo

sysadmin

14 / 20

Which Cloud providers provide a 'Private Link' to Snowflake from their Cloud platform?

AWS

Alibaba

Oracle

Azure

15 / 20

Business intelligence (BI) can be described by which of the below?

Enable analyzing, discovering, and reporting on data

Deliver data visualization through dashboards

Sometimes overlaps with technologies such Advanced Analytics.

Technology behind Time Travel and FailSafe

16 / 20

Which of below describes the function of the Metadata Management component in Services Layer?

Encryption and key Management

Handles queries that can be processed completely from metadata

Virtual Warehouse resizing policy

Used for Time Travel and Cloning

17 / 20

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

True

False

18 / 20

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

False

True

19 / 20

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

False

True

20 / 20

The SNOWFLAKE database contains information about account usage?

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.