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
What functional category does Node.js fall into?
Data Integration
Business Intelligence
SQL Editors
Security & Governance
Advanced Analytics
Programmatic Interfaces
Programmatic Interfaces
What is the name of the Snowflake-produced Command Line Interface tool?
SnowSQL
What two Tech Partner types are available from in-account menu items?
1. Partner Connect
2. Certified ANSI
3. Programmatic Interfaces
4. Founding Partnership Companies
5. HIPAA Certified
- Partner Connect
- Programmatic Interfaces
What is the best way to get the latest ODBC connector for use with Snowflake?
Download it from within the Snowflake WebUI
Which of the following have drivers/connectors (or information about where to find them) available via Help->Downloads in the Snowflake WebUI?
1. Go
2. R
3. Node.js
4. JDBC
5. Hive
6. Spark
- Go
- Node.js
- JDBC
- Spark
What makes a Partner Connect Partner different from other partners?
1. Can be connected to Snowflake using a streamlined wizard
2. Can be connected from within the WebUI
3. Includes a streamlined Partner Trial Account Signup
4. Includes automated role, user and staging database set up
5. Requires Enterprise Edition
- Can be connected to Snowflake using a streamlined wizard
- Can be connected from within the WebUI
- Includes a streamlined Partner Trial Account Signup
- Includes automated role, user and staging database set up
What are some differences between a Tech Partner and a Solution Partner?
1. Solution Partners offer consulting and implementation services
2. Wipro is an example of a Solution Partner
3. Slalom is an example of a Technology Partner
4. Tech Partners offer software, drivers or interfaces
5. Matillion is an example of a Tech Partner
6. Tech Partners offer consulting and implementation services
- Solution Partners offer consulting and implementation services
- Wipro is an example of a Solution Partner
- Tech Partners offer software, drivers or interfaces
- Matillion is an example of a Tech Partner
If you find a data-related tool that is not listed as part of the Snowflake ecosystem, what industry standard options could you check for as a way to easily connect to Snowflake?
1. Check to see if the tool can connect to other solutions via ODBC
2. Check to see if you can develop a driver and put it on Github
3. Check to see if there is a petition in the community to create a driver
4. Check to see if the tool can connect to other solutions via JDBC
- Check to see if the tool can connect to other solutions via ODBC
- Check to see if the tool can connect to other solutions via JDBC
What are the names of the four Snowflake Editions?
Standard
Premier
Enterprise
Business Critical
Which of the following Snowflake Editions automatically store data in an encrypted state?
Standard
Premier
Enterprise
Business Critical
ALL OF THEM!
ALL OF THEM!
