Architecture Overview Flashcards

1
Q

Supported Data Types in Snowflake

A

Most basic SQL data types

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Cloning in Snowflake

A

Cloning in Snowflake is a relatively unique feature to Snowflake. This allows for direct replication of an object.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What objects can be cloned in Snowflake?

A
  • Databases
  • Schemas
  • Non-temporary tables
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Cloned Object inheritance

A

Cloned Objects inherit the parameter values set at the account level by default, but can be overwritten by individual objects.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Do changes made to the source of a clone flow over to the clone?

A

No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Requirements to create a clone tables?

A

You must have SELECT access to that table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Requirements to create clones for pipes, streams, or tasks?

A

OWNERSHIP access on the object.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Requirements to create a clone for remaining objects? (excluding table, pipes, streams, and tasks)

A

USAGE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Does a clone contribute to overall data storage costs?

A

Only after the clone has been modified from its source.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Secure Data Sharing

A

Enables selected objects in a database within your account to be shared with other Snowflake accounts.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Objects that can be shared with Secure Data Sharing

A
  • Tables
  • External Tables
  • Secure Views
  • Secure Materialized Views
  • Secure UDFs
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Access Writes on shared database objects?

A

Read-only

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Are there any limits on the shares you can export/import as a provider/consumer?

A

No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Is any data copied with Secure Data Sharing?

A

No, all sharing is accomplished through Snowflake’s Cloud Services Layer, so shared data does not take up any storage in the consumers account.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Shares

A

Snowflake enables the sharing of databases through shares, which are created by data providers and imported by consumers.

Shares are named objects that encapsulate all the information required to share a database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Components of a Share

A
  • Privileges that grant access to the database(s) and the schema(s) containing the objects to share.
  • Privileges that grant access to the specific objects in the database.
  • The consumer accounts with which the database and its objects are shared.
17
Q

Data Provider

A

Any Snowflake account that creates shares and makes them available to other Snowflake accounts to consume. As a provider you share a database with one or more Snowflake account.

18
Q

Data Consumer

A

Any account that chooses to create a database from a share made available by a provider.

Once a shared database is added to your account you may query that database just as you would any other database in your account.

19
Q

Can data sharing be done between non-Snowflake accounts?

A

No, you must create a Snowflake reader account if your Consumer is not ready to become a Snowflake customer.

20
Q

Who does a reader account belong to?

A

It belongs to the Provider account that created it.

21
Q

Limitations of a Reader Account?

A

Reader Accounts can query data that has been shared with it, but cannot perform any DML tasks allowed with a full account.

22
Q

Snowflake Data Marketplace

A

Data Marketplace uses Snowflake Secure Data Sharing to connect providers of data with Consumers directly within Snowflake itself.

This allows for third party data providers to provide datasets directly into your Snowflake account to query without transformation.

Snowflake Data Marketplace provides a single location to source this data from various vendors.

23
Q

Snowflake Marketplace Availability

A

Data Marketplace is available to all Snowflake accounts except for Azure Government hosted accounts and VPS accounts.

24
Q

Role Requirements to create Databases from Snowflake Marketplace

A

Users/role with the IMPORT SHARE privilege are the only ones who can create databases from Snowflake Marketplace.

25
Q

Types of Data Listing

A
  • Standard Data Listings

- Personalized Data Listings

26
Q

Standard Data Listings

A

Provides instant access to a published data set. This is best for generic, aggregated, non-customer specific datasets. This includes details about the data, sample queries, and information about the data provider.

27
Q

Personalized Data Listings

A

Allows for customers to request specific data sets. These can be premium datasets or data specific to a customer of that provider.

Each listing includes details about the shared data, sample usage examples, and information about the data provider.

28
Q

How to join Snowflake Marketplace?

A

You must request to join the Marketplace as a provider using Snowsight web forms or through the Snowflake website.

29
Q

Data Exchange

A

Data Exchange is a data hub for securely collaborating around data between a selected group of members/consumers It enables providers to PRIVATELY publish data to be discovered by consumers (invite only).

30
Q

The main difference between Data Exchange and Data Marketplace?

A

Data Exchange is invite only and private, Data Marketplace is mostly public and open.

31
Q

Data Exchange Admin

A

The account that hosts the Data Exchange and is responsible for for configuring the Data Exchange and managing members (providers/consumers).

32
Q

Data Exchange benefits

A
  • Break down data silos
  • Exchange data between business units internal to your company
  • Collaborate with external parties such as vendors, suppliers, partners, and customers.
  • Find and consume data on other Data Exchanges to get business insights.
33
Q

Snowflake Elastic Storage & Compute

A

Due to the separation of compute and storage within Snowflake, this allows for efficient scaling and elasticity within a warehouse, leading to cost savings all around.

34
Q

Difference between traditional warehouses and elasticity with Snowflake

A

In traditional warehouses compute and storage are usually provisioned ahead of time and are harder/impossible to scale or change in the middle of a subscription.

With Snowflake, you only pay for the storage you use that month, and can scale up/down/out compute according to demand.

35
Q

Snowflake Organizations

A

An organization is a first-class Snowflake object that links accounts owned by your business entity.

36
Q

What are Snowflake Organizations used for?

A
  • Simplify Account Management and Billing
  • Database Replication
  • Failover/Failback
  • Secure Data Sharing
  • Misc admin tasks
37
Q

Snowflake Cloud Partners

A
  • Amazon Web Services (AWS)
  • Microsoft Azure
  • Google Cloud Platform (GCP)
38
Q

Scripting Connectors

A
  • Python
  • Spark
  • Kafka
  • Node.js
  • Go
  • .NET
  • JDBC (Java)
  • PHP