Practice Test 1 Flashcards

1
Q

Which term is used to describe Snowflake’s architecture?

A

Multi-cluster, shared data warehouse

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

What appears on the top bar of the Snowflake UI?

Databases

Warehouses

Tables

Worksheets

Shares

Account (for admins)

History

Partner connect, help, notifications (top right side)

Drop down menu for user (top right side)

A

Databases

Warehouses

Worksheets

Shares

Account (for admins)

History

Partner connect, help, notifications (top right side)

Drop down menu for user (top right side)

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

What are the Snowflake editions?

A

Standard, Premier, Enterprise, Enterprise for Sensitive Data (ESD), and Virtual Private Snowflake (VPS)

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

What’s the factor when you increase the t-shirt size of warehouse? 2, 4, 6, or 8?

A

2

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

Snowflake is designed for which type of workloads? (select all that apply)

OLAP (analytics) workloads

OLTP (transactional) workloads

Concurrent workloads

On-premises workloads

A

OLAP

Concurrent

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

Which of the following are Cloud-native solutions? Select all that apply.

Google Big Query

Snowflake

Both

A

both

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

What are the three things customers want most from their enterprise data warehouse solution?

A

Concurrency

Query Performance

Simplicity

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

A Snowflake deployment runs in which environment?

A

Region

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

Does AWS Private Link allow customers to connect their on prem VPC ?

A

YES

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

Which of the following can you clone?

User

Table

Schema

Databases

Views

Shares

A

Table
Schema
Database

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

True or false: The Query Profiler view is only available for completed queries.

A

False

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

What are some of the items the services layer in Snowflake manages? Select all that apply

User authentication

Metadata

Query Compilation and Optimization

Data Security

A

All

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

What types of data does Snowflake support natively? Select all that apply.

Structured, relational data

Semi-structured data such as JSON and AVRO

A

All

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

Where is metadata stored?

Global services layer

Virtual warehouse layer

Data storage layer

Customer’s local place

A

Global services layer

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

True or False: A micropartition will be updated as updates are made to the rows of the data it contains

A

False

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

True/False: When a clone of a table is created, the original table’s data is physically copied?

A

False

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

True/False: Fail safe is configurable.

A

False

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

Do all tables have fail safe?

A

No

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

Which features are direct results of Snowflake’s storage management approach? Select all that apply.

Time Travel

Zero-copy cloning

Fail safe

A

Time Travel

Zero Copy Cloning

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

In order to view the storage usage of all tables in a db, you can use: (Select all that apply)

SHOW TABLES;

SHOW STORAGE BY TABLE;

INFORMATION_SCHEMA.TABLE_STORAGE_METRICS

INFORMATION_SCHEMA.TABLE_HISTORY

A

show tables;

NFORMATION_SCHEMA.TABLE_STORAGE_METRICS

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

True/False: A single schema can exist in more than one database in SF

A

False

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

What’s the maximum row size?

8 MB

16 MB

50 MB

4000 GB

A

16MB

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

True or False: The database storage in Snowflake is split across the nodes like other Shared nothing databases.

A

True

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

True/False: Zero-copy cloning is an additional feature of Snowflake available for Enterprise edition and up

A

False

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

What kind of data format is JSON?

Semi-structured

Unstructured

Structured

A

semi structured

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

What methods can be used to create and/or manage Virtual Warehouses?

A

Snowflake Web Interface

SQL commands

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

When does a warehouse come out of suspended state (2 ways)

A

When it is auto-resumed

When a query is run

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

What is the default time for auto-suspend?

A

10 min

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

Warehouses size up between t-shirt sizes by a factor of what?

A

2

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

Which of the following does SF not support?
insert
upsert
merge

A

upsert

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

How many threads does a single Virtual Machine within a Compute Cluster contain?

A

8

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

True/False: The user has to specify which cluster a query will run on in a multi-cluster warehouse.

A

False

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

When scaling up virtual warehouses by increasing virtual warehouse t-shirt size, you are primary scaling for improved:

Performance

Concurrency

Simplicity

On-Prem accessibility

A

performance

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

True/False: The minimum time that a warehouse is charged is 5 mins.

A

False

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

True or false: You can resize a Virtual Warehouse while queries are running.

A

True

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

True or false: It is a best practice in Snowflake to break large tables into partitions to improve query performance.

A

False

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

Why would you scale a Virtual Warehouse UP?

Complex queries

Large datasets

More workloads

A

Complex Queries

Large Datasets

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

Why would you scale a Virtual Warehouse OUT?

Handle concurrency

Handle complex query

A

Concurrency

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

Which of the following commands could run without a warehouse running, assuming no previous queries have been run? Check all that apply:

sum(<>)

min(<>)

Select * from table

copy

avg(<>)

A

min(col name)

40
Q

Whats the command for creating Virtual Warehouse

CREATE VIRTUAL_WAREHOUSE

CREATE WAREHOUSE

A

create warehouse

41
Q

True or False: It is possible to query data stored in Snowflake without a Virtual Warehouse.

A

True

42
Q

True or false: You need an active warehouse to run a basic insert statement.

A

True

43
Q

Name the 3 serverless functions in SF (no need for virtual warehouse)

A

auto-clustering (pay only when it wakes up )

snowpipe (pay for the compute used to execute COPY INTO)

materialized views

44
Q

Select all the editions In which you can use multi-cluster warehouses?

Standard

Premium

Enterprise

Enterprise for Sensitive Data (EDS)/Business Critical

VPS

A

Enterprise and higher.

45
Q

What is the optimal size for loading files into Snowflake?

A

10-100mb compressed

46
Q

You need to specify the file format when loading data into Snowflake

A

False

47
Q

What is the maximum row size (compressed) in Snowflake?

A

16mb

48
Q

How is Snowpipe charged?

A

per second/per core granularity

49
Q

What command do you use to put files from a local file system into an internal stage?

A

PUT

50
Q

True/False: You can use the PUT command in the UI

A

False

51
Q

Snowflake supports which of the following file formats for data unloading?

CSV/TSV

Json

Parquet

A

all

52
Q

Which of the following are supported by the COPY statement?

Joins

Aggregates

Concatenate

Ordering

Filtering

A

concatenate

ordering

53
Q

Which edition(s) of Snowflake provide up to 90 days of time travel?

A

Enterprise, ESD, VPS

54
Q

How many days of time travel do you get for Standard and Premier editions?

A

1 day

55
Q

Snowflake supports multi-factor authentication (MFA) to provide increased login security for users connecting to Snowflake. Which statements are true about MFA security?

MFA is automatically enabled for your account and available for all users to self-enroll

MFA is an integrated feature powered by the Duo Security Service

MFA can be used for connecting to Snowflake via the Snowflake JDBC driver

A

MFA is an integrated feature powered by the Duo Security Service

56
Q

Which connectors support multi-factor authentication?

A

Pretty much all of them: UI, JDBC, ODBC, SnowSQL

57
Q

true or false: Snowflake charges a premium for storing semi-structured data?

A

false

58
Q

What column type is used to store semi-structured data?

A

variant

59
Q

What type of data would you use the FLATTEN function for?
Structured data

Semi-structured data

Both of the above

None of the above

A

semi structured

60
Q

T/F STRIP_NULL_VALUE converts a JSON “NULL” value to a SQL Null value?

A

True

61
Q

What are the two ways to create and manage shares in Snowflake

A

Use SQL commands

Via Snowflake Web UI

62
Q

How many shares can a data provider provide?

A

unlimited

63
Q

Who pays for the storage of the data being shared?

A

data provider

64
Q

Who pays the compute cost for queries run on a data share?

A

Data consumer, data provider pays compute cost for reader accounts

65
Q

Data sharing is available starting in which edition?

A

standard

66
Q

True/False: You can clone a data share in Snowflake.

A

false

67
Q

What happens when data providers revoke privileges on a share on an object?

A

it’s unavailable

68
Q

What are the four default roles in Snowflake?

A

ACCOUNTADMIN, SYSADMIN, SECURITYADMIN, PUBLIC

69
Q

True/False: A single database can exist in more than one Snowflake account.

A

False

70
Q

Which of the following contributes to an account’s compute cost?

Warehouse size

The number of clusters

The amount of data queried

A

Warehouse size

The number of clusters

71
Q

What can monitor account-level credit and storage usage

A

Resource Monitor

72
Q

Identify concerns about legacy data sharing.

Date volume

Data security

Data governance

A

All

73
Q

Which role should be in charge of managing database objects?

SYSADMIN

ACCOUNT ADMIN

SECURITY ADMIN

PUBLIC

A

Sysadmin

74
Q

True/False: Roles are a subset of users. Users own objects which allows the role to access those objects.

A

False

75
Q

What does snowflake recommend for best practices for the accountadmin/sysadmin roles? Check all that apply (not exact answers, but something along these lines)

Make default role sysadmin (if a user has both)

Create all objects using the accountadmin role (definitely don’t check this one)

Use the sysadmin role for general administration of tasks

Only enter the accountadmin role to perform tasks for this role, then leave the role once you’ve finished those tasks.

A

Make default role sysadmin (if a user has both)

Only enter the accountadmin role to perform tasks for this role, then leave the role once you’ve finished those tasks.

76
Q

Select all that apply: Which of the following are blocking operators?

MERGE

UPDATE

INSERT

COPY

A

merge

update

77
Q

True/False: When a clone of a table is created, the original table’s data is physically copied?

A

false

78
Q

Would scaling up (increasing Warehouse size) or out (adding more Cluster to the Warehouse) help a complex query perform better?

A

up

79
Q

What technique does Snowflake use to limit the number of micro-partitions scanned by each query?

A

clustering

80
Q

True/False It’s best practice to have a clustering key in every table?

A

false

81
Q

True/False: All tables in SF are clustered.

A

false

82
Q

You can use Snowflake on the following cloud services (select all that apply):

Amazon Web Services

Microsoft Azure

Google Cloud Provider (in preview)

A

all

83
Q

What can you download through UI?

SnowSQL

ODBC Driver

A

all

84
Q

Snowflake’s query language is based on:

A

sql

85
Q

Which of the following objects can not be cloned

Table

User

Share

Stage

View

File format

A

user
share
view

86
Q

The fact that micro-partition is immutable support which of the following feature

Zero-copy cloning

Time travel

Fail safe

Clustering

A

zero copy cloning

time travel

87
Q

How much uncompressed data is in a micro-partition?

A

50-500mb

88
Q

What is the most used connector?

A

jdbc

89
Q

What is the best place to find information on connectors and tool integration?

A

snowflake docs

90
Q

What is the name of the feature that allows you to analyze a visual representation of the query execution?

A

query profiler

91
Q

Shared databases are read-only in Snowflake?

A

true

92
Q

True/False: Query the files in an external stages directly without loading?

A

false

93
Q

Which Snowflake functions can be run in Snowsql but not the Web UI?

GET

PUT

COPY

A

get

put

94
Q

Which Snowflake layer has caching?

Global Service

Virtual Warehouse

Storage

A

all

95
Q

True or False: Snowflake can be deployed in a hybrid cloud or private cloud environment?

A

false

96
Q

Which Snowflake role is strongly recommended to enable MFA?

SYSADMIN

ACCTADMIN

SECURITYADMIN

Both SYSADMIN and ACCTADMIN

A

acctadmin

97
Q

We can load file through Snowpipe without using a stage

A

false