Section 1 Questions Flashcards

1
Q

What attributes make Snowflake a true SaaS solution?

A

-No hardware to purchase or configure
-No maintenance upgrades or patches to install
-Transparent releases don’t require user intervention

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

Which installment option versions of Snowflake are available?

A

-Snowflake-Hosted Accounts (on Amazon cloud infrastructure)
-Snowflake-Hosted Accounts (on Google Cloud Platform infrastructure)
-Snowflake-Hosted Accounts (on Azure cloud infrastructure)

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

What best describes Snowflake’s Architecture?

A

Shared data

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

What are four terms or phrases to describe Snowflake?

A

-Native SQL
-Hybrid Columnar
-Built from the ground up for the cloud
-Multi cluster

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

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

A. Snowflake Tables are stored within Schemas.
F. Snowflake Schemas are stored within Databases

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

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

A

B. Compressed Size
E. Amount Stored - Daily Average

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

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

A

B. Persistent data stored in permanent tables
C. Data retained to enable data recovery (time travel and fail-safe)

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

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.

A

B. The amount of time warehouses have run.
D. The sizes of running warehouses.

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

How often does Snowflake release new features?

A

Weekly

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

What common tasks for traditional on-premises database and IT staff are not required with Snowflake?

A

-Maintaining metadata
-Maintaining statistics
-Maintaining the physical security of a server room (key cards, door locks, etc.)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
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
12
Q

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.

A
  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. 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
13
Q

What functional category does Matillion fall into?
Data Integration
Business Intelligence
SQL Editors
Security & Governance
Advanced Analytics
Programmatic Interfaces

A

Data Integration

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

What functional category does Looker fall into?
Data Integration
Business Intelligence
SQL Editors
Security & Governance
Advanced Analytics
Programmatic Interfaces

A

Business Intelligence

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

What functional category does Databricks fall into?
Data Integration
Business Intelligence
SQL Editors
Security & Governance
Advanced Analytics
Programmatic Interfaces

A

Advanced Analytics

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

What functional category does Node.js fall into?
Data Integration
Business Intelligence
SQL Editors
Security & Governance
Advanced Analytics
Programmatic Interfaces

A

Programmatic Interfaces

17
Q

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

A

SnowSQL

18
Q

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

A
  1. Partner Connect
  2. Programmatic Interfaces
19
Q

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

A

Download it from within the Snowflake WebUI

20
Q

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

A
  1. Go
  2. Node.js
  3. JDBC
  4. Spark
21
Q

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

A
  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
22
Q

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

A
  1. Solution Partners offer consulting and implementation services
  2. Wipro is an example of a Solution Partner
  3. Tech Partners offer software, drivers or interfaces
  4. Matillion is an example of a Tech Partner
23
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?
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

A
  1. Check to see if the tool can connect to other solutions via ODBC
  2. Check to see if the tool can connect to other solutions via JDBC
24
Q

What are the names of the four Snowflake Editions?

A

Standard
Premier
Enterprise
Business Critical

25
Q

Which of the following Snowflake Editions automatically store data in an encrypted state?
Standard
Premier
Enterprise
Business Critical
ALL OF THEM!

A

ALL OF THEM!