Level up Flashcards
what are the six workloads of snowflake
data engineering, data lake, data warehouse, data science, data application, data exchange
what are the four layers of snowflake’s architecture
compute, storage, services, cloud agnostic layer
Who can provide the compute resource used by Snowflake for data loading jobs?
User-managed virtual warehouse (bulk). Snowflake-managed serverless compute (streaming).
what is disaster recovery approach?
replication & failover/failback functionalities
what are the features of replication & failover/failback functionalities?
account object replication. database replication. client redirect
what type of failures are handled automatically by snowflake?
single instance failure (triple redundancy for critical services & automatic query retries). zone failure (availability zones).
what type of failures are handled by user/admin?
user error (zero copy clone, time travel). region failure (cross-region database replication and failover). multi-region failure (cross-cloud database replication and failover)
what actions can be performed using time travel?
querying. create clones of tables, schemas or databases. restore tables, schemas or databases
Which of the following are performed by the Cloud Services layer?
Metadata Management. Metadata Storage. User Authentication. Data Security.
Which of the following terms describes Snowflake’s Architecture?
share data
Snowflake data storage costs are calculated based on:
Compressed Size & Amount Stored - Daily Average
Snowflake Ecosystem Tech Partners are classified into which of the following 6 functional categories?
Data Integration, Business Intelligence, SQL Editors, Security and Governance, Advanced Analytics, Programmatic Interfaces
Which of the following have drivers/connectors (or information about where to find them) available via Help->Downloads in the Snowflake WebUI?
Go. Node.js. JDBC. Spark
Which of the following industry compliance standards has Snowflake been audited and certified for?
SOC1, 2., PCI DSS, FedRAMP, HIPAA
what are the type of snowflake caches?
metadata, result, warehouse (local).
centralized storage (remote) –> not considered cache
Which of the following could be considered synonymous with the term “Warehouse Cache”?
Raw data cache, data cache, SSD cache
