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 has a default file format if none is explicitly set?

True

False

2 / 20

A transient table will be dropped when the user session that created it ends?

False

True

3 / 20

What is the maximum size of each micro partition (compressed data)?

1mb

160mb

10mb

16mb

4 / 20

Which of the below are examples of Technical Partners offerings?

Business Intelligence

SQL Editors

Security & Governance

Data Integration

5 / 20

Which of the below are Valid Snowflake Editions?

Business Focused

Virtual Private

Express

Enterprise

6 / 20

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

Index all columns used in Predicate clause

Clustering

Search Optimisation

Materialized Views

7 / 20

There is a limit of 100 databases that can be replicated per account?

False

True

8 / 20

Which information below can we view about a query that has run in the past?

Bytes scanned

Duration

QueryID

Warehouse

9 / 20

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

Data Masking

Intrusion Monitoring

SQL Optimisation

Risk Assessment

10 / 20

Stored Procedures can only be written in Javascript?

True

False

11 / 20

DATA_RETENTION_TIME_IN_SECONDS is used to define the Time Travel duration?

True

False

12 / 20

Which of the below are attributes of a Named Stage?

Created manually

Ownership can not be transferred

Can't be dropped

Can be altered

13 / 20

What is the purpose of a Network Policy?

Allowlisting

Define a new AAA record for Snowflake account

Blocklisting

Define a new CNAME for Snowflake account

14 / 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

15 / 20

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

A user with useradmin Role can grant privilege

A role with the MANAGE GRANTS privilege can grant privilege

The schema owner can grant privilege

User that created the object can grant privilege

16 / 20

All tables are natural Clustered based on data ingestion order?

False

True

17 / 20

Which best describes the useradmin Role?

Role dedicated to user and role management

Top level role in the system

Pseudo role that is automatically granted to every user

Role that can manage any object grant globally

18 / 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

Failsafe

Undo

Flashback

19 / 20

Streams are a form of Change Data Capture (CDC)?

False

True

20 / 20

The Time Travel feature allows customers to restore there data back to ANY time in the past since the database was created?

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.