Section 1 Questions Flashcards
What attributes make Snowflake a true SaaS solution?
-No hardware to purchase or configure
-No maintenance upgrades or patches to install
-Transparent releases don’t require user intervention
Which installment option versions of Snowflake are available?
-Snowflake-Hosted Accounts (on Amazon cloud infrastructure)
-Snowflake-Hosted Accounts (on Google Cloud Platform infrastructure)
-Snowflake-Hosted Accounts (on Azure cloud infrastructure)
What best describes Snowflake’s Architecture?
Shared data
What are four terms or phrases to describe Snowflake?
-Native SQL
-Hybrid Columnar
-Built from the ground up for the cloud
-Multi cluster
Which statements are true about storage relationships?
Select the correct options from the list
A. Snowflake Tables are stored within Schemas.
B. Snowflake Databases are stored within Warehouses
C. Snowflake Warehouses are stored within Data Marts
D. Snowflake Schemas are stored within Warehouses
E. Snowflake Warehouses are stored within Databases
F. Snowflake Schemas are stored within Databases
A. Snowflake Tables are stored within Schemas.
F. Snowflake Schemas are stored within Databases
Snowflake data storage costs are calculated based on:
Select the correct options from the list
A. Uncompressed Size
B. Compressed Size
C. Amount Stored on Last Day of Month
D. Amount Stored on First Day of Month
E. Amount Stored - Daily Average
B. Compressed Size
E. Amount Stored - Daily Average
Snowflake data storage costs include which types of data?
Select the correct options from the list
A. Metadata
B. Persistent data stored in permanent tables
C. Data retained to enable data recovery (time travel and fail-safe)
D. Cached results
E. Semi-structured data - additional fees
B. Persistent data stored in permanent tables
C. Data retained to enable data recovery (time travel and fail-safe)
Snowflake compute costs depend on which of the following?
Select the correct options from the list
A. The number of rows returned in queries.
B. The amount of time warehouses have run.
C. The total number of warehouses in the account.
D. The sizes of running warehouses.
B. The amount of time warehouses have run.
D. The sizes of running warehouses.
How often does Snowflake release new features?
Weekly
What common tasks for traditional on-premises database and IT staff are not required with Snowflake?
-Maintaining metadata
-Maintaining statistics
-Maintaining the physical security of a server room (key cards, door locks, etc.)
Snowflake Ecosystem Tech Partners are classified into which of the following functional categories?
Data Integration
Business Intelligence
SQL Editors
Security and Governance
Advanced Analytics
Programmatic Interfaces
Which statements about Data Integration Tech Partners are true?
1. Data Integration Tech Partner software can be used to extract data from other systems.
2. Data Integration Tech Partner software can be used to carry out transformations.
3. Snowflake can carry out transformations after loading files staged by partner software (ELT).
4. Snowflake must be used to extract data from other databases but Data Integration Tech Partner software can load data.
5. Snowflake can be used to extract data from other databases but Data Integration Tech Partner software must be used to do transformations.
6. Data Integration Tech Partner software should be used to deliver data to stages, Snowflake is then used to load the data.
- Data Integration Tech Partner software can be used to extract data from other systems.
- Data Integration Tech Partner software can be used to carry out transformations.
- Snowflake can carry out transformations after loading files staged by partner software (ELT).
- Data Integration Tech Partner software should be used to deliver data to stages, Snowflake is then used to load the data.
What functional category does Matillion fall into?
Data Integration
Business Intelligence
SQL Editors
Security & Governance
Advanced Analytics
Programmatic Interfaces
Data Integration
What functional category does Looker fall into?
Data Integration
Business Intelligence
SQL Editors
Security & Governance
Advanced Analytics
Programmatic Interfaces
Business Intelligence
What functional category does Databricks fall into?
Data Integration
Business Intelligence
SQL Editors
Security & Governance
Advanced Analytics
Programmatic Interfaces
Advanced Analytics