General Flashcards
How many databases can you have per share
one
What is the limit for the number of shares you can create
no hard limit
What is the limit for the number of accounts you can add to a share
no hard limit
What metrics does the data provider have when consumers access a data share
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
What database objects can be shared
Tables
External Tables
Secure Views
Secure Materialized views
secure udfs
What does each share consist of
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
T/F Data sharing is only supported between Snowflake Accounts
True
Who does the reader account belong to
The provider account that created it
T/F A consumer using a reader account can consume shares from anyone
False - only the provider account that created the reader account
What three product offerings are there for data sharing
Direct Share
Snowflake Marketplace
Data Exchange
What users can manage a Data Exchange
An account admin or a user with IMPORT PRIVILEGES granted
How do you grant import privileges to a rol
grant import privileges on data exhange ‘exchange_name’ to ‘role_name’
When a role is granted IMPORT PRIVILEGES, what does SHOW GRANTS show
USAGE
What rights or user do you have tobe do use the Private Sharing page in Snowsight
AccountAdmin or a role that has been granted the CREATE SHARE or IMPORT SHARE
What tasks can be performed on an inbound share
Create a database from the share
View all shares from the providers and the data sharing mechanism used
What tasks can be performed for outbound shares
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
To share a table, what access needs to be granted to the share
USAGE on Database and schema
SELECT on table
T/F If you share across different regions or cloud platforms, a database with one or more external tables will blocked
True
T/F Creating secure views on streams is not recommended
True, instead, allow consumers to create their own streams on the tables and secure views you share.
how do you add multiple accounts to a share
alter share share_name add accounts=xyz12345, xyz8908
For secure views based on tables in multiple databases, which additional privilege must be granted
REFERENCE_USAGE on every database that is not the database where the secured view is created
Which editions support data sharing
Standard, Enterprise, and Business Critical (not VPS)
Partner Connect is limited to which role
AcccountAdmin
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
True
T/F autosuspend applies to the whole cluster and not individual instances
True
Can you create temporary and non-temporary tables with the same name within the same schema?
Yes
Snowflake limits the size of query text (i.e. SQL statements) submitted through Snowflake clients to..?
1 MB per statement
T/F Snowpark is GA
False, it is preview only
What is the default size for warehouses created using CREATE WAREHOUSE?
X Small
What is the default size for warehouses created in the web interface?
X Large
What are the types of Snowflake’s product releases?
Full
Behavioral Change Release
Batch Release
What Actions or Triggers does a Resource Monitor Support
Notify & Suspend
Notify & Suspend Immediately
Notify
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
Each Resource Monitor can have what number of actions
One Suspend Action
One Suspend Immediate Action
Up to Five Notify Actions
Roles need to be granted what privileges on a specific resource monitor in order to view or modify the resource
MONITOR
MODIFY
STATEMENT_TIMEOUT_IN_SECONDS can be set at what levels
Account
User
Session
Warehouse
What Languages are supported for created UDFs
Java
JavaScript
Python
SQL
Snowflake deploys new releases at what frequency
weekly
What method does Snowflake use to limit the number of micro-partitions accessed during a query?
Pruning
The “load metadata” (which maintains which files have already been loaded) for a table expires after how many days?
64
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
What are the Database Privileges
MODIFY
MONITOR
USAGE
CREATE SCHEMA
IMPORTED PRIVILEGES
OWNERSHIP
ALL
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
what endpoint reports files recently submitted via insertFiles and ingested into a table
insertReport
which endpoint fetches a report about ingested files whose contents have been added to a table
loadHistoryScan
T/F If you’re in the middle of running queries when you refresh, they will resume running when the refresh is completed
True
What are the system defined roles
ORGADMIN
ACCOUNTADMIN
SECURITYADMIN
USERADMIN
SYSADMIN
PUBLIC
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
What is the purpose of USERADMIN
Dedicated to user and role management only
What privileges does USERADMIN have
CREATE USER
CREATE ROLE
What is the purpose of SYSADMIN
To create warehouses and databases
USERADMIN is granted to what role via the system role hierarchy
SECURITYADMIN
Which role is granted the MANAGE GRANTS security privilege
SECURITYADMIN
What is the purpose of SECURITYADMIN
Can manage object grants globally as well as create, monitor, and manage users and roles
A session can have how many primary and secondary roles
one active primary role
any number of secondary roles
When an object is created, its ownership is set to which role
the currently active primary role
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
All commands in SnowSQL start with what?
an exclamation point
What are the two scaling modes
Maximized
Auto Scaling
What is it called when the value of the min clusters is equal to the value of the max clusters
Maximized
What are the scaling policies
Standard
Economy