Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Snow Pro certification > Level 3 - Snowflake Ecosystem > Flashcards

Level 3 - Snowflake Ecosystem Flashcards

1
Q

Snowflake Ecosystem Tech Partners are classified into which of the following functional categories?

A

Data Integration
Business Intelligence
SQL Editors
Security and Governance
Advanced Analytics
Programmatic Interfaces

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which statements about Data Integration Tech Partners are true?

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What functional category does Matillion fall into?

A

Data Integration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What functional category does Looker fall into?

A

Business Intelligence

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What functional category does Node.js fall into?

A

Programmatic Interfaces

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is the name of the Snowflake-produced Command Line Interface tool?

A

SnowSQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What two Tech Partner types are available from in-account menu items?

A

Partner Connect
Programmatic Interfaces

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the best way to get the latest ODBC connector for use with Snowflake?

A

Download it from within the Snowflake WebUI

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which of the following have drivers/connectors (or information about where to find them) available via Help->Downloads in the Snowflake WebUI?

A

Go
Node.js
JDBC
Spark

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What makes a Partner Connect Partner different from other partners?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What are some differences between a Tech Partner and a Solution Partner?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly

Snow Pro certification (8 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions