• ¿Documento equivocado? Cámbialo gratis
  • Escrito por estudiantes que aprobaron
  • Inmediatamente disponible después del pago
  • Leer en línea o como PDF
Vender
¿Dónde estudias?
Tu idioma
Document preview thumbnail
Vista previa 2 fuera de 14 páginas
Caso

Snowflake SnowPro Certification Study Guide

Document preview thumbnail
Vista previa 2 fuera de 14 páginas

What are the 3 Cloud Providers available for Snowflake 1) AWS - a provider since inception 2) Azure Cloud Platforms - generally available as of Sept. 2018 3) Google Cloud Platform - trialed late 2019 Snowflake is currently the only DW built for the cloud (T/F) True

Vista previa del contenido

Snowflake SnowPro Certification Study Guide
Study online at https://quizlet.com/_7ygrjb

1) AWS - a provider since inception
2) Azure Cloud Platforms - generally
What are the 3 Cloud Providers available
available as of Sept. 2018
for Snowflake
3) Google Cloud Platform - trialed late
2019
Snowflake is currently the only DW built
True
for the cloud (T/F)
How does Snowflake describe their ar-
chitecture?
A) Multi-Cluster, Shared Data
A) Multi-Cluster, Shared Data
B) Single-Cluster, Shared Data
What are the 3 components of 1) Storage - Databases
Snowflake's architecture (both the name 2) Compute - Virtual Warehouses
and descriptor) 3) Cloud Services - Front End
1) AWS S3
What are the Cloud Object Storage op-
2) Azure Blobs
tions?
3) GCP
A daily average of all compressed data
storage, including data stored according
How are storage costs calculated?
to Time Travel retention policy and fail-
safe procedures
Which Microsoft and Amazon systems 1) AWS EC2
does Compute leverage? 2) Azure Compute
Compute can't scale out as queries are
False
running (T/F)
1) Security Management
Which services does Cloud Services 2) Infrastructure Management
provide? 3) Metadata Management
4) Query Optimization
Are Snowflake's Storage (DB) and Com-
pute (WH) layers
A) Separate and Independent
A) Separate and Independent
B) Together and Dependent

Scale up or down automatically


, Snowflake SnowPro Certification Study Guide
Study online at https://quizlet.com/_7ygrjb
In addition to multiple Virtual Warehous-
es, Multi-Cluster means individual Virtual
Warehouses can...
Multi-Cluster turn off clusters when activ-
True
ity slows down (T/F)
Snowflake uses ANSI-SQL (T/F) True
What is Snowflake's semi-structured
VARIANT
data type called?
1) Warehouse
What are the three types of caching in
2) Metadata
Snowflake?
3) Results
All cache data are cleared if the underly-
True
ing data changes (T/F)
Stores data that's been loaded into Vir-
What does Warehouse Caching do?
tual Warehouses during querying. The
When is the data invalidated? Where
data is invalidated if it's suspended. Lives
does it live?
in Compute.
What does Metadata Caching do? It stores various info about tables. It lives
Where does it live? in the Cloud Services layer.
It stores results of queries that have been
What does Results Caching do? Where executed within the past 24 hours (as-
does it live? suming underlying data hasn't changed).
It lives in the Cloud Services Layer.
A customer needs to have a preexisting
account with AWS or Azure in order to False
have a Snowflake account (T/F)
What are Availability Zones? Data centers in certain regions
How many availability zones is your data
3 data zones in a region
replicated in?
A partition scheme doesn't need to be
What does it mean by "automatic" mi-
defined up front. Snowflake determines
cro-partitions
and creates it.
Data partitioning is automatically com-
True
pleted in the natural ingestion order (T/F)

Información del documento

Subido en
4 de diciembre de 2024
Número de páginas
14
Escrito en
2024/2025
Tipo
Caso
Profesor(es)
Snowflake
Grado
A+
$9.49

¿Documento equivocado? Cámbialo gratis Dentro de los 14 días posteriores a la compra y antes de descargarlo, puedes elegir otro documento. Puedes gastar el importe de nuevo.
Escrito por estudiantes que aprobaron
Inmediatamente disponible después del pago
Leer en línea o como PDF

Seller avatar
Los indicadores de reputación están sujetos a la cantidad de artículos vendidos por una tarifa y las reseñas que ha recibido por esos documentos. Hay tres niveles: Bronce, Plata y Oro. Cuanto mayor reputación, más podrás confiar en la calidad del trabajo del vendedor.
Exammate
2.7
(10)
Vendido
65
Seguidores
8
Artículos
3181
Última venta
1 mes hace



Por qué los estudiantes eligen Stuvia

Creado por compañeros estudiantes, verificado por reseñas

Calidad en la que puedes confiar: escrito por estudiantes que aprobaron y evaluado por otros que han usado estos resúmenes.

¿No estás satisfecho? Elige otro documento

¡No te preocupes! Puedes elegir directamente otro documento que se ajuste mejor a lo que buscas.

Paga como quieras, empieza a estudiar al instante

Sin suscripción, sin compromisos. Paga como estés acostumbrado con tarjeta de crédito y descarga tu documento PDF inmediatamente.

Student with book image

“Comprado, descargado y aprobado. Así de fácil puede ser.”

Alisha Student

Preguntas frecuentes