Practice Test #2 Flashcards

1
Q

Snowflake’s micro-partitions directly enable which of the following features?

Zero-copy cloning

Data sharing

Time travel

Bulk/continuous data loading

A

zero copy cloning

time travel

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

True or false: There is a difference in storage cost allocation between structured and semi-structured data.

A

false

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

True or false: Data stored in time travel and fail safe incur storage cost.

A

true

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

True or false: Once a table created through zero-copy cloning is modified, the modified data will be stored as new blocks and incur storage cost.

A

true

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

True or false: Time travel is enabled for all Snowflake accounts

A

true

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

True or false: The clustering depth for a table is not an absolute or precise measure of whether the table is well-clustered.

A

true. query performance is the best indicator.

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

Clustering depth is useful for:

Monitoring the clustering “health” of a large table

Determining whether a large table would benefit from explicitly defining a clustering key

A

both

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

True or false: Maintaining clustering of a column that has very high cardinality is more expensive than maintaining clustering of a column that has much lower cardinality.

A

true

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

True or false: Manually sort rows on key table columns and re-insert them into the table could be expensive.

A

true

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

True or false: A table with a clustering key defined is considered to be clustered.

A

true

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

true or false: The compute resources used to perform clustering does not consume credits.

A

false

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

True or false: All tables should be clustered to improve query efficiency.

A

false

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

True or false: Generally, the more frequently a table changes, the more expensive it will be to keep it clustered.

A

true

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

True or false: Putting a higher cardinality column before a lower cardinality column will generally reduce the effectiveness of clustering on the latter column

A

true

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

What should you consider before defining a clustering key for a table?

A

Associated credit & storage costs

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

True or false: A table can only have one clustering key at a time.

A

true

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

True or false: Snowflake only reclusters a clustered table if it will benefit from the operation.

A

true

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

True or 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
19
Q

True or false: A Data Provider can create a share for a consumer account location in a different cloud region.

A

false, must be from same region

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

What are the two ways to create a share?

A

sql

web ui

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

True or false: Data providers can share any views and/or UDFs with data consumers.

A

False: Can share secure views & secure UDFs only.

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

True or false: Not all editions of Snowflake support data sharing.

A

True. VPS doesn’t support it.

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

Which of the following can a data consumer do? Select all that apply.

Create a clone from a shared DB / schema / table

Time travel for a shared DB / schema / table

Modify any of the information in the shared DB / schema / table

Edit the comments for a shared DB / schema / table

A

none

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

t/f All objects in a share must be from the same DB?

A

true

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

True or false: A Data provider may grant privilege to a table without granting the privilege to the schema that the table belongs to,.

A

False: Must grant it to any container objects before granting to objects inside the container

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

True or false: A data provider may add an account before granting usage on a DB.

A

False: It will result in an error

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

Which function is used to convert nested values into separate columns?

A

FLATTEN

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

True or false: The steps for loading semi-structured data into tables are identical to those for loading structured data into relational tables.

A

TRUE

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

What are the semi-structure data types that Snowflake supports? HINT - there are 5.

A

JSON, Avro, Parquet, XML, ORC

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

What is the maximum row size for VARIANT data type?

A

16mb

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

Using the Snowflake Web UI, one can:

Create & manage users

Create Virtual WH

Load data

Create databases

A

ALL

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

True or false: You can use the Query Profile to monitor queries that have not finished executing.

A

True

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

The Query Profile shows:

Query status

Query ID

Warehouse

User

A

All

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

True or false: The syntax for loading data is COPY INTO

A

False

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

True or false: The syntax for unloading data is COPY INTO

A

True

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

True or false: A warehouse must be running in order to perform DELETE.

A

True

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

True or false: A warehouse consumes credits even when it’s in suspended state.

A

False

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

How many credits/hour doe a Small-sized warehouse consume?

A

2

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

How do we consider while calculating the number of credits billed for a multi-cluster warehouse?

Number of servers per cluster

Number of times the warehouse scale up and/or down

Number of clusters that run within the period

Whether auto-resume and/or auto-suspend is on

A

Number of servers per cluster

Number of clusters that run within the period

40
Q

True or false: Large warehouse always executes queries faster than a small warehouse.

A

False

41
Q

True or false: Auto-suspend is enabled by default by Snowflake.

A

False

42
Q

True or false: You may apply auto-suspend to an individual cluster in a warehouse.

A

False

43
Q

True or false: The default warehouse for a user is used as the warehouse for all sessions initiated by the user.

A

True

44
Q

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

MERGE

UPDATE

INSERT

COPY

A

merge

update

45
Q

Scaling policy for a multi-cluster warehouse? Choose 2

Standard

Economy

Optimized

Maximized

A

standard

economy

46
Q

Which of the following are types of caching use by Snowflake? Select all that apply?

Metadata caching

Query result caching

Warehouse Caching

A

all

47
Q

True or false: Snowflake only works with cloud-based tools.

A

false

48
Q

True or false: You can use GET command in the UI.

A

false

49
Q

What objects can you support time travels on?

A

tables, schemas, databases

50
Q

What are the different types of tables?

Persistent

Temporary

Transient

Permanent

A

Temporary

Transient

Permanent

51
Q

What can you download through UI?

SnowSQL

ODBC Driver

JDBC Driver

A

ODBC Driver

JDBC Driver

52
Q

How often does Snowflake release updates?

Once a week

Once every two weeks

Once month

There is no set schedule

A

once a week

53
Q

How to see your clustering information? Select all apply

SYSTEM$CLUSTERING_INFORMATION

SYSTEM$CLUSTERING_KEYS

SYSTEM$CLUSTERING_DEPTH

SYSTEM$CLUSTERING_RATIO

A

SYSTEM$CLUSTERING_INFORMATION

SYSTEM$CLUSTERING_DEPTH

54
Q

Account Usage includes dropped objects.

A

true

55
Q

Information Schema includes dropped objects.

A

false

56
Q

True or false: You can clone a share.

A

false

57
Q

You can grant usage of an object to a user as long as you have the SYSADMIN role.

A

false

58
Q

Which languages can be used to create user-defined functions?

SQL

JAVASCRIPT

JAVA

Python

A

sql

javascript

59
Q

How long does query history stay in INFORMATION_SCHEMA?

A

1 year

60
Q

How long does query history stay in the UI?

A

14 days

61
Q

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

A

false

62
Q

True or false: SECURITYADMIN has the highest privileges among all roles.

A

false

63
Q

True or false: When a Snowflake account is created, the account automatically comes with three out-of-the-box roles: ACCOUNTADMIN, SECURITYADMIN, and SYSADMIN.

A

false

64
Q

True or false: Users own objects which allows the role to access those objects.

A

false

65
Q

True or false: Two databases with the same cannot be under the same account.

A

true

66
Q

What can be used to limit the number of credits consumed?

A

resource monitors

67
Q

True or false: Cloud-based data sharing can be nearly instantaneous, i.e. independent of data size.

A

true

68
Q

Can you access anything in the Global Services Layer?

A

no

69
Q

Which term is used to describe Snowflake’s architecture?

A

multi cluster shared data wh

70
Q

What is the full name of the highest Snowflake edition?

A

virtual private snowflake

71
Q

Which of the following doesn’t belong to the top bar in the UI?

Shares

Tables

Credit Usage

History

A

tables

credit usage

72
Q

True or false: Snowflake is great for OLAP workload.

A

true

73
Q

True or false: A single Snowflake deployment can run in multiple regions as long as the right permissions are granted.

A

false

74
Q

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

A

false

75
Q

True or false: Auto-clustering feature is only available for certain Snowflake editions.

A

false

76
Q

Which of the following does SF not support?

Upsert

Insert

Merge

A

upsert

77
Q

Why would you scale a Virtual Warehouse OUT?

A

handle concurrency

78
Q

Which of the following table types have no fail-safe feature enabled?

Temporary

Transient

Permanent

A

temporary

transient

79
Q

Which of the following table types have time-travel feature enabled?

Temporary

Transient

Permanent

A

all

80
Q

Which of the following are serverless functions?

Auto-clustering

Snowpipe

Materialized Views

UDFs

A

Auto-clustering

Snowpipe

Materialized Views

81
Q

What is the default file format for data loading if you do not specify one?

A

csv

82
Q

True or false: When active, a pipe required a dedicated warehouse to execute against it.

A

false

83
Q

true or false: Snowpipe only works with internal stages.

A

false

84
Q

True or false: MFA is only for SSO

A

false

85
Q

True or false: All data in Snowflake is encrypted

A

true

86
Q

True or false: End-to-end encryption feature is only available for some Snowflake editions.

A

false

87
Q

How many shares can a data providers create?

A

unlimited

88
Q

How many shares can a data consumer consume?

A

unlimited

89
Q

True or false: Data sharing is only available for some Snowflake editions.

A

true

90
Q

True or false: You cannot modify tables in shared databases in Snowflake.

A

true

91
Q

Can customers still use Snowflake while the releases are rolling out?

A

Yes, because there’s no down time for customers

92
Q

True or false: In Snowflake, only NOT NULL constraint is enforced.

A

true

93
Q

Which layer is the result set cache located?

A

services layer

94
Q

Does SF external staging require the customer to encrypt the data before transmission?

A

yes

95
Q

Can you configure fail-safe?

A

no

96
Q

True or false: A stored procedure may return a value whereas a UDF must return a value.

A

true