Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Snowflake > Level up > Flashcards

Level up Flashcards

1
Q

what are the six workloads of snowflake

A

data engineering, data lake, data warehouse, data science, data application, data exchange

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

what are the four layers of snowflake’s architecture

A

compute, storage, services, cloud agnostic layer

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

Who can provide the compute resource used by Snowflake for data loading jobs?

A

User-managed virtual warehouse (bulk). Snowflake-managed serverless compute (streaming).

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

what is disaster recovery approach?

A

replication & failover/failback functionalities

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

what are the features of replication & failover/failback functionalities?

A

account object replication. database replication. client redirect

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

what type of failures are handled automatically by snowflake?

A

single instance failure (triple redundancy for critical services & automatic query retries). zone failure (availability zones).

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

what type of failures are handled by user/admin?

A

user error (zero copy clone, time travel). region failure (cross-region database replication and failover). multi-region failure (cross-cloud database replication and failover)

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

what actions can be performed using time travel?

A

querying. create clones of tables, schemas or databases. restore tables, schemas or databases

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

Which of the following are performed by the Cloud Services layer?

A

Metadata Management. Metadata Storage. User Authentication. Data Security.

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

Which of the following terms describes Snowflake’s Architecture?

A

share data

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

Snowflake data storage costs are calculated based on:

A

Compressed Size & Amount Stored - Daily Average

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

Snowflake Ecosystem Tech Partners are classified into which of the following 6 functional categories?

A

Data Integration, Business Intelligence, SQL Editors, Security and Governance, Advanced Analytics, Programmatic Interfaces

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

Which of the following have drivers/connectors (or information about where to find them) available via Help->Downloads in the Snowflake WebUI?

A

Go. Node.js. JDBC. Spark

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

Which of the following industry compliance standards has Snowflake been audited and certified for?

A

SOC1, 2., PCI DSS, FedRAMP, HIPAA

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

what are the type of snowflake caches?

A

metadata, result, warehouse (local).
centralized storage (remote) –> not considered cache

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

Which of the following could be considered synonymous with the term “Warehouse Cache”?

A

Raw data cache, data cache, SSD cache

Snowflake (2 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions