C - Snowflake Level Up Step 3-4
What functional category does Matillion fall into? Data Integration Business Intelligence SQL Editors Security & Governance Advanced Analytics Programmatic Interfaces
Data Integration
Which industry compliance standards has Snowflake been audited and certified for?
SOC 1 SOC Type 2 PCI DSS FedRAMP HIPAA
What is the name of the Snowflake-produced Command Line Interface tool?
SnowSQL
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!
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.
1, 2, 3, and 6 are true
The following questions have to do cloud platforms. Mark all the statements that are true. 1. A company can use more than one cloud infrastructure provider by setting up several Snowflake accounts. 2. A company can have its data stored in more than one geographical region by setting up several Snowflake accounts 3. A company can use a combination of data sharing and replication to distribute data to various regions and cloud platforms 4. A company can use availability zones to distribute data to various regions and cloud platforms
1. A company can use more than one cloud infrastructure provider by setting up several Snowflake accounts. 2. A company can have its data stored in more than one geographical region by setting up several Snowflake accounts 3. A company can use a combination of data sharing and replication to distribute data to various regions and cloud platforms
Which cloud infrastructure providers are available as platforms?
AWS, Azure, and GCP
Snowflake Ecosystem Tech Partners are classified into which of the following functional categories? 1. Data Integration 2. Business Intelligence 3. SQL Editors 4. Security & Governance 5. Advanced Analytics 6. Programmatic Interfaces
All of the above
Which of the following Snowflake Editions encrypt all data transmitted over the network within a Virtual Private Cloud (VPC)?
Business Critical edition
What functional category does Looker fall into? Data Integration Business Intelligence SQL Editors Security & Governance Advanced Analytics Programmatic Interfaces
Business Intelligence
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
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
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
1. Check to see if the tool can connect to other solutions via ODBC 4. Check to see if the tool can connect to other solutions via JDBC
When setting up a new Snowflake Account, what steps or choices must the enrollee complete? 1. Choose a Cloud Infrastructure Provider 2. Choose a Cloud Compliance Standard 3. Choose a Snowflake Edition 4. Choose a Geographic Deployment Region 5. Choose an Availability Zone 6. Choose the billing and account management cloud provider
1. Choose a Cloud Infrastructure Provider 3. Choose a Snowflake Edition 4. Choose a Geographic Deployment Region
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
1. Go 3. Node.js 4. JDBC 6. Spark
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
1. Partner Connect 3. Programmatic Interfaces
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
1. Solution Partners offer consulting and implementation services 2. Wipro is an example of a Solution Partner 4. Tech Partners offer software, drivers or interfaces 5. Matillion is an example of a Tech Partner
When signing up for a new Snowflake Account, enrollees first choose a cloud infrastructure provider and then a region. When choosing Azure, an enrollee might then choose the "Australia East" region. When choosing AWS, the "Australia East" region is not listed. Instead, a region called, "Asia Pacific (Sydney)" is listed. Why? 1. Snowflake does not allow AWS-based Accounts to use the "Asia Pacific (Sydney)" region 2. Snowflake retired the "Australia East" region before AWS-based accounts were in use 3. Each cloud provider maintains its own regions and names the regions as they see fit 4. The availability zones in "Asia Pacific (Sydney)" are incompatible with Azure partition sizes
3. Each cloud provider maintains its own regions and names the regions as they see fit
What functional category does Databricks fall into? Data Integration Business Intelligence SQL Editors Security & Governance Advanced Analytics Programmatic Interfaces
Advanced Analytics
What is the best way to get the latest ODBC connector for use with Snowflake?
Download it from within the Snowflake WebUI
What functional category does Node.js fall into? Data Integration Business Intelligence SQL Editors Security & Governance Advanced Analytics Programmatic Interfaces
Programmatic Interfaces
When choosing a geographic deployment region, what two factors might an enrollee consider?
Proximity to the point of service and Number of availability zones within a region