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 best way to choose the right Warehouse size is to?

Submit a statspack report to Snowflake Support to advise

Monitor warehouse load on each Warehouse

Experiment running the same query on different Warehouses

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

2 / 20

The is a limit of 10 on the number of data shares a consumer can utilise?

True

False

3 / 20

Which of the below is an example of a Solution Partners services?

helping to tune your premise database

Assisting with performance optimization

Helping you migrate or implement Snowflake

Assisting with design, preparation, re-platforming

4 / 20

Which Port is used for General SnowFlake traffic?

1521

8080

443

22

5 / 20

Time Travel Syntax can include which of the below?

BEFORE

AT

RECOVER

FLASHBACK

6 / 20

Which of the below are true about a TASK in Snowflake?

Schedule interval set in minutes or a CRON expression

Task dependencies on other Tasks can be created

Schedule SQL execution

Optionally use with Streams

7 / 20

The COPY INTO command supports transaction control whereas Snowpipe does not?

False

True

8 / 20

What are the 3 layers in the Snowflake architecture?

Monitoring Layer

Compute Layer

Storage Layer

Services Layer

9 / 20

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

3

2

1

4

10 / 20

Only the Snowflake Support can perform data restores using FailSafe?

True

False

11 / 20

What are the types of Caching available in Snowflake?

Metadata

Results

Storage

Warehouse

12 / 20

Which of the below best describes Snowflake Architecture?

Data Shares

Shared data

Shared nothing

Shared disk

13 / 20

Time Travel can only be defined and used at the Database level?

True

False

14 / 20

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

ARRAY_AGG

PARSE_JSON

SEMI_STRUCT_DECODE

FLATTERN

15 / 20

What is the purpose of a Network Policy?

Define a new AAA record for Snowflake account

Allowlisting

Blocklisting

Define a new CNAME for Snowflake account

16 / 20

Which of the below are true of the Optimise Service?

SQL plan baselines and Profiles

Automatic Join order optimisation

Pruning using metadata and statistics

Automatic Stats gathering

17 / 20

What are the 2 types of Stage in Snowflake?

External

Internal

Clustered

Standalone

18 / 20

Time Travel is NOT available in Standard Edition?

True

False

19 / 20

Which best describes the securityadmin Role?

Top level role in the system

Role that can manage any object grant globally

Pseudo role that is automatically granted to every user

Role privileges to create warehouses and databases

20 / 20

What must we specify when loading a file directly from External Cloud Storage into Snowflake without the use of a stage?

File Location

Credentials

USE EXTERNAL CLOUD STORAGE clause

Encryption Key

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.