General Flashcards
(153 cards)
1
Q
How many databases can you have per share
A
one
2
Q
What is the limit for the number of shares you can create
A
no hard limit
3
Q
What is the limit for the number of accounts you can add to a share
A
no hard limit
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
5
Q
What database objects can be shared
A
Tables
External Tables
Secure Views
Secure Materialized views
secure udfs
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
7
Q
T/F Data sharing is only supported between Snowflake Accounts
A
True
8
Q
Who does the reader account belong to
A
The provider account that created it
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
10
Q
What three product offerings are there for data sharing
A
Direct Share
Snowflake Marketplace
Data Exchange
11
Q
What users can manage a Data Exchange
A
An account admin or a user with IMPORT PRIVILEGES granted
12
Q
How do you grant import privileges to a rol
A
grant import privileges on data exhange ‘exchange_name’ to ‘role_name’
13
Q
When a role is granted IMPORT PRIVILEGES, what does SHOW GRANTS show
A
USAGE
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
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
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
17
Q
To share a table, what access needs to be granted to the share
A
USAGE on Database and schema
SELECT on table
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
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.
20
Q
how do you add multiple accounts to a share
A
alter share share_name add accounts=xyz12345, xyz8908
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
22
Q
Which editions support data sharing
A
Standard, Enterprise, and Business Critical (not VPS)
23
Q
Partner Connect is limited to which role
A
AcccountAdmin
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
25
T/F autosuspend applies to the whole cluster and not individual instances
True
26
Can you create temporary and non-temporary tables with the same name within the same schema?
Yes
27
Snowflake limits the size of query text (i.e. SQL statements) submitted through Snowflake clients to..?
1 MB per statement
28
T/F Snowpark is GA
False, it is preview only
29
What is the default size for warehouses created using CREATE WAREHOUSE?
X Small
30
What is the default size for warehouses created in the web interface?
X Large
31
What are the types of Snowflake’s product releases?
Full
Behavioral Change Release
Batch Release
32
What Actions or Triggers does a Resource Monitor Support
Notify & Suspend
Notify & Suspend Immediately
Notify
33
In Resource Monitoring, what is the difference between Notify and Notify and Suspend immediately
Notify and Suspend will wait for all statements being executed by the warehouse to be completed
34
Each Resource Monitor can have what number of actions
One Suspend Action
One Suspend Immediate Action
Up to Five Notify Actions
35
Roles need to be granted what privileges on a specific resource monitor in order to view or modify the resource
MONITOR
MODIFY
36
STATEMENT_TIMEOUT_IN_SECONDS can be set at what levels
Account
User
Session
Warehouse
37
What Languages are supported for created UDFs
Java
JavaScript
Python
SQL
38
Snowflake deploys new releases at what frequency
weekly
39
What method does Snowflake use to limit the number of micro-partitions accessed during a query?
Pruning
40
The "load metadata" (which maintains which files have already been loaded) for a table expires after how many days?
64
41
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?
ACCOUNTADMIN
Users with a role granted the MONITOR USAGE global privilege
42
What are the Database Privileges
MODIFY
MONITOR
USAGE
CREATE SCHEMA
IMPORTED PRIVILEGES
OWNERSHIP
ALL
43
Describe the insertFiles endpoint
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
44
what endpoint reports files recently submitted via insertFiles and ingested into a table
insertReport
45
which endpoint fetches a report about ingested files whose contents have been added to a table
loadHistoryScan
46
T/F If you’re in the middle of running queries when you refresh, they will resume running when the refresh is completed
True
47
What are the system defined roles
ORGADMIN
ACCOUNTADMIN
SECURITYADMIN
USERADMIN
SYSADMIN
PUBLIC
48
T/F The PUBLIC role cannot own securable objects
False, they can but the objects are then available to every other user and role in the account
49
What is the purpose of USERADMIN
Dedicated to user and role management only
50
What privileges does USERADMIN have
CREATE USER
CREATE ROLE
51
What is the purpose of SYSADMIN
To create warehouses and databases
52
USERADMIN is granted to what role via the system role hierarchy
SECURITYADMIN
53
Which role is granted the MANAGE GRANTS security privilege
SECURITYADMIN
54
What is the purpose of SECURITYADMIN
Can manage object grants globally as well as create, monitor, and manage users and roles
55
A session can have how many primary and secondary roles
one active primary role
any number of secondary roles
56
When an object is created, its ownership is set to which role
the currently active primary role
57
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?
True
58
All commands in SnowSQL start with what?
an exclamation point
59
What are the two scaling modes
Maximized
Auto Scaling
60
What is it called when the value of the min clusters is equal to the value of the max clusters
Maximized
61
What are the scaling policies
Standard
Economy
62
What file formats are supported for loading
Delimited files
JSON
avro
ORC
Parquet
XML is only in preview
63
Creating a stage that uses a storage integration requires what privileges
CREATE STAGE for the schema
USAGE on the storage integration
64
The role with ownership on the stage must have what privilege on the storage integration
USAGE
65
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
True, but you must have the USAGE privilege on the stage
66
What are the data load REST endpoints
insertFiles
insertReport
loadHistoryScan
67
What is the purpose of the Search Optimization Service
it can significantly improve the performance of certain types of lookups and analytical queries that use an extensive set of predicates for filtering
68
Of these three, which have storage and compute costs
Search Optimization Service
Materialized View
Clustering the table
Search Optimization Service
Materialized View
69
To add, configure, or remove search optimization for a table, you must have what privileges
OWNERSHIP on the table
ADD SEARCH OPTIMIZATION on the schema that contains the table
70
How might you identify table that benefit from search optimization
Improve the performance of a query when the table is frequently queried on columns other than the primary cluster key.
71
What type of privilege is SELECT, INSERT, UPDATE, DELETE, TRUNCATE
Table Privileges
72
What type of privilege is MONITOR USAGE, CREATE SHARE, CREATE ACCOUNT
Global privileges
73
Currently, users can choose between what two behaviors in terms of how Snowflake clients or drivers respond during an OCSP event.
Fail-Open
Fail-Close
74
T/F Snowflake supports using unencrypted private keys with SnowSQL
True
75
Snowflake provides what open specification to help facilitate the automated management of user identities and groups?
SCIM
76
T/F there is no guarantee that files are loaded in the same order they are staged
True
77
T/F When using Bulk Load, Loads are always performed in a single transaction
True
78
T/F Search optimization supports external tables
False
79
T/F Search optimization does no t support tables and views protected by row access policies
True
80
T/F Search optimization does not support column concatenation
True
81
T/F Search optimization supports analytical expressions
False
82
T/F Search optimization supports materialized view
False
83
When using the REST endpoints for Snowpipe, what authentication is required
JSON Web Token (JWT)
84
Support for AWS Private Link and Azure Private Link requires what edition or higher
Business Critical
85
How to retrieve a JSON representation of the Pipe Status?
SYSTEM$PIPE_STATUS
86
Snowflake tracks the resource consumption of loads for all pipes in an account, with what granularity?
per-second/per-core
87
T/F In standard mode, each successive warehouse waits to start 20 seconds after the prior one
True
88
Max number of warehouses that can be defined in the multi cluster warehouse are
10
89
T/F Bulk loaded relies on user-provided virtual warehouses
True
90
T/F Using the warehouse page in the web ui, you can transfer the ownership of a warehouse to a different role
True
91
T/F Search optimization aims to significantly improve the performance of selective point lookup queries on tables
True
92
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
Standard
93
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?
Snowpipe ignores modified files that are staged again
94
The snowflake web interface wizard has a loading limit of what when loading flat files to a table
50 MB
95
T/F If you log out of Snowflake, any active queries continue running
False
96
T/F In the snowflake web ui, under databases, you can unload data
False
97
Valid execution states for a pip are
Paused, stopped_missing_pipe, running
98
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.
True
99
The Snowflake SCIM Api can address what use cases
Manage Users
Manage Roles
Auditing
100
Internal Stages: What are the different stage types
User, Table, Named
101
What is a User Stage
Allocated to each user for storing files. Managed by a single user, cannot be altered or dropped
102
What is a Table Stage
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
T/F a table stage has no grantable privileges of its own
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
What is a named stage
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
Automated snowpipe cross cloud support is only available to accounts hosted on what cloud platform
AWS
106
T/F UDF will contribute to your account level usage
False
107
How big is the data in micropartitions, uncompressed?
50 -500 MB
108
T/F Micropartitions are immutable
True
109
What metadata is stored for each micropartition
Range of values of each column
Count of distinct values for each column
Additional Metadata Used for optimization
110
If a warehouse is requested to be suspended, what happens to active queries
They must be completed before the warehouse will be suspended.
111
T/F The virtual warehouse's cache is dropped when the warehouse is suspended
True
112
A cost is associated if you are
* Transfering Data In
* Transfering Data Out
* Both
Transfering Data Out
113
What are the serverless compute costs
Snowpipe
Automatic Clustering
Database Replication
Materialized View
Search Optimization
114
What are the three type of internal stages
Named
Table
User
115
T/F a table stage can be dropped
False, it is there for the life of the table
116
T/F a table stage can load to multiple tables
false, only the table it is attached to
117
How do you reference an internal stage
@internal_stage_name
118
T/F a materialized view on an external table does not automatically refresh
True
119
The load metadata for a table expires after how many days?
64
120
You are required to store JSON data in a Snowflake table. Which data type will you use?
Variant
121
T/F An external table can only be created against an external stage
True
122
The clone comand supports what objects
Databases
Schemas
Tables
Streams
Stages
File Format
Sequences
Tasks
123
What can't be cloned
External tables
Internal Named Stages
124
T/F Min Max is not stored in the metadata cache if it is a character column
True
125
Automatic Clustering Service is responsible for what activity in Snowflake?
Redistributing data in micro partitions according to the cluster key
126
An external function’s code executes in which location?
Outside of Snowflake
127
True or False: Snowflake supports only Scalar external functions?
True. Snowflake supports only scalar external functions, i.e., the function should return only one value.
128
True or False: Snowflake Scripting be used to create stored procedures.
True
129
True or False: Snowpark can push down your user-defined functions to the server, where the code then operates on the data.
True
130
T/F Snowflake SQL UDFs can return either Scalar or Tabular results?
True
131
T/F Snowflake patch releases are applied to all accounts at the same time.
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
T/F TO_NUMBER AND TO_NUMERIC are both valid conversions
True
133
T/F Yaml is a supported file format
False
134
T/F Shares can be cloned
False
135
T/F You can concatenate columns in the copy command
True
136
In the Snowflake staged release process for new releases, which account types are applied updates the LAST?
Enterprise and Higher Accounts
137
T/F Transpose can be used while loading data through the COPY command?
False
138
T/F Under the Download section in Snowflake Web UI, Python Components are available for download
True
139
T/F When cloning data you can use CREATE_COPY to force a copy of the data
False, no such command
140
When a database or a schema is cloned, snowpipes hooked up to what stages are cloned
Any that are not hooked up to an internal stage
141
How many databases per share
one
142
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.
False
143
T/F When a virtual warehouse is resized to a smaller size, the cache associated with the servers is dropped?
True
144
T/F In a Worksheet, you can select the Schema along with the Database, warehouse, and role
True
145
T/F If a virtual warehouse is suspended it is likely that the results stored in its cache will be cleared.
True
146
T/F SCALING_POLICY is a valid option when creating a new multicluster virtual warehouse
True
147
T/F Shares can be cloned
False
148
T/F Sequences can be cloned
False
149
T/F An ACCOUNTADMIN can see the results of any query executed by any user in a Snowflake system?
False, even if you had the rights to see all the queries, the page only displays info, not the results
150
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.
False, only needs to be replicated once
151
What is not available for replication
Temporary tables, stages, tasks, pipes, and external tables are not currently supported for replication.
152
What can be cloned
Databases, Tables, Schemas, Stages, File Formats, Tasks, Sequences, and Streams
153
What can be shared
Tables, External tables, Secure views, Secure materialized views, Secure UDFs.
