General Flashcards

1
Q

How many databases can you have per share

A

one

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

What is the limit for the number of shares you can create

A

no hard limit

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

What is the limit for the number of accounts you can add to a share

A

no hard limit

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

What metrics does the data provider have when consumers access a data share

A

Consumer’s Snowflake Account Name
Consumer’s Snowflake Org name
Statistical data on consumption including date, and the number of queries ran
Any info consumer provides when submitting the data request

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

What database objects can be shared

A

Tables
External Tables
Secure Views
Secure Materialized views
secure udfs

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

What does each share consist of

A

the privileges that grant access to the database and the schema containing the objects to share
the privs that grant access to the specific objects
the consumer accounts with which the database and the objects are shared

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

T/F Data sharing is only supported between Snowflake Accounts

A

True

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

Who does the reader account belong to

A

The provider account that created it

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

T/F A consumer using a reader account can consume shares from anyone

A

False - only the provider account that created the reader account

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

What three product offerings are there for data sharing

A

Direct Share
Snowflake Marketplace
Data Exchange

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

What users can manage a Data Exchange

A

An account admin or a user with IMPORT PRIVILEGES granted

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

How do you grant import privileges to a rol

A

grant import privileges on data exhange ‘exchange_name’ to ‘role_name’

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

When a role is granted IMPORT PRIVILEGES, what does SHOW GRANTS show

A

USAGE

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

What rights or user do you have tobe do use the Private Sharing page in Snowsight

A

AccountAdmin or a role that has been granted the CREATE SHARE or IMPORT SHARE

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

What tasks can be performed on an inbound share

A

Create a database from the share
View all shares from the providers and the data sharing mechanism used

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

What tasks can be performed for outbound shares

A

View the share - includes the database, the consumer accounts, date when the share was created, and the objects that have been shared
Create a share/data listing
Edit a share/data listing
revoke access to the share for individual consumer accounts

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

To share a table, what access needs to be granted to the share

A

USAGE on Database and schema
SELECT on table

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

T/F If you share across different regions or cloud platforms, a database with one or more external tables will blocked

A

True

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

T/F Creating secure views on streams is not recommended

A

True, instead, allow consumers to create their own streams on the tables and secure views you share.

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

how do you add multiple accounts to a share

A

alter share share_name add accounts=xyz12345, xyz8908

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

For secure views based on tables in multiple databases, which additional privilege must be granted

A

REFERENCE_USAGE on every database that is not the database where the secured view is created

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

Which editions support data sharing

A

Standard, Enterprise, and Business Critical (not VPS)

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

Partner Connect is limited to which role

A

AcccountAdmin

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

T/F when sharing a view across regions or cloud platforms, and the view references multiple databases, each of these other databases must be replicated

A

True

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

T/F autosuspend applies to the whole cluster and not individual instances

A

True

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

Can you create temporary and non-temporary tables with the same name within the same schema?

A

Yes

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

Snowflake limits the size of query text (i.e. SQL statements) submitted through Snowflake clients to..?

A

1 MB per statement

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

T/F Snowpark is GA

A

False, it is preview only

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

What is the default size for warehouses created using CREATE WAREHOUSE?

A

X Small

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

What is the default size for warehouses created in the web interface?

A

X Large

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

What are the types of Snowflake’s product releases?

A

Full
Behavioral Change Release
Batch Release

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

What Actions or Triggers does a Resource Monitor Support

A

Notify & Suspend
Notify & Suspend Immediately
Notify

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

In Resource Monitoring, what is the difference between Notify and Notify and Suspend immediately

A

Notify and Suspend will wait for all statements being executed by the warehouse to be completed

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

Each Resource Monitor can have what number of actions

A

One Suspend Action
One Suspend Immediate Action
Up to Five Notify Actions

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

Roles need to be granted what privileges on a specific resource monitor in order to view or modify the resource

A

MONITOR
MODIFY

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

STATEMENT_TIMEOUT_IN_SECONDS can be set at what levels

A

Account
User
Session
Warehouse

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

What Languages are supported for created UDFs

A

Java
JavaScript
Python
SQL

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

Snowflake deploys new releases at what frequency

A

weekly

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

What method does Snowflake use to limit the number of micro-partitions accessed during a query?

A

Pruning

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

The “load metadata” (which maintains which files have already been loaded) for a table expires after how many days?

A

64

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

Which Account or user type can use the Snowflake web interface or SQL to view the credits billed to your Snowflake account within a specified date range?

A

ACCOUNTADMIN
Users with a role granted the MONITOR USAGE global privilege

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

What are the Database Privileges

A

MODIFY
MONITOR
USAGE
CREATE SCHEMA
IMPORTED PRIVILEGES
OWNERSHIP
ALL

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

Describe the insertFiles endpoint

A

informs snowflake the files to be ingested into a table. A successful response means that Snowflake has recorded the list, it does not necessarily mean the files have been ingested

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

what endpoint reports files recently submitted via insertFiles and ingested into a table

A

insertReport

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

which endpoint fetches a report about ingested files whose contents have been added to a table

A

loadHistoryScan

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

T/F If you’re in the middle of running queries when you refresh, they will resume running when the refresh is completed

A

True

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

What are the system defined roles

A

ORGADMIN
ACCOUNTADMIN
SECURITYADMIN
USERADMIN
SYSADMIN
PUBLIC

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

T/F The PUBLIC role cannot own securable objects

A

False, they can but the objects are then available to every other user and role in the account

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

What is the purpose of USERADMIN

A

Dedicated to user and role management only

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

What privileges does USERADMIN have

A

CREATE USER
CREATE ROLE

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

What is the purpose of SYSADMIN

A

To create warehouses and databases

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

USERADMIN is granted to what role via the system role hierarchy

A

SECURITYADMIN

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

Which role is granted the MANAGE GRANTS security privilege

A

SECURITYADMIN

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

What is the purpose of SECURITYADMIN

A

Can manage object grants globally as well as create, monitor, and manage users and roles

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

A session can have how many primary and secondary roles

A

one active primary role
any number of secondary roles

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

When an object is created, its ownership is set to which role

A

the currently active primary role

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

T/F Snowflake Client repository provider SnowSQL Installer requires no authentication for downloading and this version of the SnowSQL installer enables auto-upgrade for patches?

A

True

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

All commands in SnowSQL start with what?

A

an exclamation point

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

What are the two scaling modes

A

Maximized
Auto Scaling

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

What is it called when the value of the min clusters is equal to the value of the max clusters

A

Maximized

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

What are the scaling policies

A

Standard
Economy

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

What file formats are supported for loading

A

Delimited files
JSON
avro
ORC
Parquet
XML is only in preview

63
Q

Creating a stage that uses a storage integration requires what privileges

A

CREATE STAGE for the schema
USAGE on the storage integration

64
Q

The role with ownership on the stage must have what privilege on the storage integration

A

USAGE

65
Q

T/F To load or unload data from or to a stage that uses an integration, it is not necessary to have the USAGE privilege on the storage integration

A

True, but you must have the USAGE privilege on the stage

66
Q

What are the data load REST endpoints

A

insertFiles
insertReport
loadHistoryScan

67
Q

What is the purpose of the Search Optimization Service

A

it can significantly improve the performance of certain types of lookups and analytical queries that use an extensive set of predicates for filtering

68
Q

Of these three, which have storage and compute costs
Search Optimization Service
Materialized View
Clustering the table

A

Search Optimization Service
Materialized View

69
Q

To add, configure, or remove search optimization for a table, you must have what privileges

A

OWNERSHIP on the table
ADD SEARCH OPTIMIZATION on the schema that contains the table

70
Q

How might you identify table that benefit from search optimization

A

Improve the performance of a query when the table is frequently queried on columns other than the primary cluster key.

71
Q

What type of privilege is SELECT, INSERT, UPDATE, DELETE, TRUNCATE

A

Table Privileges

72
Q

What type of privilege is MONITOR USAGE, CREATE SHARE, CREATE ACCOUNT

A

Global privileges

73
Q

Currently, users can choose between what two behaviors in terms of how Snowflake clients or drivers respond during an OCSP event.

A

Fail-Open
Fail-Close

74
Q

T/F Snowflake supports using unencrypted private keys with SnowSQL

A

True

75
Q

Snowflake provides what open specification to help facilitate the automated management of user identities and groups?

A

SCIM

76
Q

T/F there is no guarantee that files are loaded in the same order they are staged

A

True

77
Q

T/F When using Bulk Load, Loads are always performed in a single transaction

A

True

78
Q

T/F Search optimization supports external tables

A

False

79
Q

T/F Search optimization does no t support tables and views protected by row access policies

A

True

80
Q

T/F Search optimization does not support column concatenation

A

True

81
Q

T/F Search optimization supports analytical expressions

A

False

82
Q

T/F Search optimization supports materialized view

A

False

83
Q

When using the REST endpoints for Snowpipe, what authentication is required

A

JSON Web Token (JWT)

84
Q

Support for AWS Private Link and Azure Private Link requires what edition or higher

A

Business Critical

85
Q

How to retrieve a JSON representation of the Pipe Status?

A

SYSTEM$PIPE_STATUS

86
Q

Snowflake tracks the resource consumption of loads for all pipes in an account, with what granularity?

A

per-second/per-core

87
Q

T/F In standard mode, each successive warehouse waits to start 20 seconds after the prior one

A

True

88
Q

Max number of warehouses that can be defined in the multi cluster warehouse are

A

10

89
Q

T/F Bulk loaded relies on user-provided virtual warehouses

A

True

90
Q

T/F Using the warehouse page in the web ui, you can transfer the ownership of a warehouse to a different role

A

True

91
Q

T/F Search optimization aims to significantly improve the performance of selective point lookup queries on tables

A

True

92
Q

Which Scaling policy follow the below consideration while doing warehouse shutdown: After 2 to 3 consecutive successful checks (performed at 1 minute intervals), which determine whether the load on the least-loaded warehouse could be redistributed to the other warehouses without spinning up the warehouse again

A

Standard

93
Q

Pipes only maintain the load history metadata for 14 days. What will happen if the same files are modified and staged again within 14 days?

A

Snowpipe ignores modified files that are staged again

94
Q

The snowflake web interface wizard has a loading limit of what when loading flat files to a table

A

50 MB

95
Q

T/F If you log out of Snowflake, any active queries continue running

A

False

96
Q

T/F In the snowflake web ui, under databases, you can unload data

A

False

97
Q

Valid execution states for a pip are

A

Paused, stopped_missing_pipe, running

98
Q

T/F Table stage type is designed to store files that are staged and managed by one or more users but only loaded into a single table.

A

True

99
Q

The Snowflake SCIM Api can address what use cases

A

Manage Users
Manage Roles
Auditing

100
Q

Internal Stages: What are the different stage types

A

User, Table, Named

101
Q

What is a User Stage

A

Allocated to each user for storing files. Managed by a single user, cannot be altered or dropped

102
Q

What is a Table Stage

A

A table stage is available for each table created in Snowflake. It stores files that are staged and managed by one or more users but only loaded into a single table. Cannot be altered or dropped

103
Q

T/F a table stage has no grantable privileges of its own

A

True, it is an implicit stage tied to the table itself. To stage, list, or query files on the stage, you must be the table owner.

104
Q

What is a named stage

A

A named internal stage is a database object created in a schema. Can store files that are staged and managed by one or more users and loaded into one or more tables.

105
Q

Automated snowpipe cross cloud support is only available to accounts hosted on what cloud platform

A

AWS

106
Q

T/F UDF will contribute to your account level usage

A

False

107
Q

How big is the data in micropartitions, uncompressed?

A

50 -500 MB

108
Q

T/F Micropartitions are immutable

A

True

109
Q

What metadata is stored for each micropartition

A

Range of values of each column
Count of distinct values for each column
Additional Metadata Used for optimization

110
Q

If a warehouse is requested to be suspended, what happens to active queries

A

They must be completed before the warehouse will be suspended.

111
Q

T/F The virtual warehouse’s cache is dropped when the warehouse is suspended

A

True

112
Q

A cost is associated if you are
* Transfering Data In
* Transfering Data Out
* Both

A

Transfering Data Out

113
Q

What are the serverless compute costs

A

Snowpipe
Automatic Clustering
Database Replication
Materialized View
Search Optimization

114
Q

What are the three type of internal stages

A

Named
Table
User

115
Q

T/F a table stage can be dropped

A

False, it is there for the life of the table

116
Q

T/F a table stage can load to multiple tables

A

false, only the table it is attached to

117
Q

How do you reference an internal stage

A

@internal_stage_name

118
Q

T/F a materialized view on an external table does not automatically refresh

A

True

119
Q

The load metadata for a table expires after how many days?

A

64

120
Q

You are required to store JSON data in a Snowflake table. Which data type will you use?

A

Variant

121
Q

T/F An external table can only be created against an external stage

A

True

122
Q

The clone comand supports what objects

A

Databases
Schemas
Tables
Streams
Stages
File Format
Sequences
Tasks

123
Q

What can’t be cloned

A

External tables
Internal Named Stages

124
Q

T/F Min Max is not stored in the metadata cache if it is a character column

A

True

125
Q

Automatic Clustering Service is responsible for what activity in Snowflake?

A

Redistributing data in micro partitions according to the cluster key

126
Q

An external function’s code executes in which location?

A

Outside of Snowflake

127
Q

True or False: Snowflake supports only Scalar external functions?

A

True. Snowflake supports only scalar external functions, i.e., the function should return only one value.

128
Q

True or False: Snowflake Scripting be used to create stored procedures.

A

True

129
Q

True or False: Snowpark can push down your user-defined functions to the server, where the code then operates on the data.

A

True

130
Q

T/F Snowflake SQL UDFs can return either Scalar or Tabular results?

A

True

131
Q

T/F Snowflake patch releases are applied to all accounts at the same time.

A

True The patch releases are applied to all accounts at the same time. The staged released process is only used for new software releases.

132
Q

T/F TO_NUMBER AND TO_NUMERIC are both valid conversions

A

True

133
Q

T/F Yaml is a supported file format

A

False

134
Q

T/F Shares can be cloned

A

False

135
Q

T/F You can concatenate columns in the copy command

A

True

136
Q

In the Snowflake staged release process for new releases, which account types are applied updates the LAST?

A

Enterprise and Higher Accounts

137
Q

T/F Transpose can be used while loading data through the COPY command?

A

False

138
Q

T/F Under the Download section in Snowflake Web UI, Python Components are available for download

A

True

139
Q

T/F When cloning data you can use CREATE_COPY to force a copy of the data

A

False, no such command

140
Q

When a database or a schema is cloned, snowpipes hooked up to what stages are cloned

A

Any that are not hooked up to an internal stage

141
Q

How many databases per share

A

one

142
Q

T/F In order to share data as a producer and consume data as a consumer you must have two separate Snowflake accounts, one for sharing data and one for consuming shared data.

A

False

143
Q

T/F When a virtual warehouse is resized to a smaller size, the cache associated with the servers is dropped?

A

True

144
Q

T/F In a Worksheet, you can select the Schema along with the Database, warehouse, and role

A

True

145
Q

T/F If a virtual warehouse is suspended it is likely that the results stored in its cache will be cleared.

A

True

146
Q

T/F SCALING_POLICY is a valid option when creating a new multicluster virtual warehouse

A

True

147
Q

T/F Shares can be cloned

A

False

148
Q

T/F Sequences can be cloned

A

False

149
Q

T/F An ACCOUNTADMIN can see the results of any query executed by any user in a Snowflake system?

A

False, even if you had the rights to see all the queries, the page only displays info, not the results

150
Q

T/F When setting up replication for cross cloud or cross region data sharing, the data provider must replicate data once for each data consumer.

A

False, only needs to be replicated once

151
Q

What is not available for replication

A

Temporary tables, stages, tasks, pipes, and external tables are not currently supported for replication.

152
Q

What can be cloned

A

Databases, Tables, Schemas, Stages, File Formats, Tasks, Sequences, and Streams

153
Q

What can be shared

A

Tables, External tables, Secure views, Secure materialized views, Secure UDFs.