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