General Flashcards
Sharing, Cloning, Replication: Tables
All for tables, except can’t replicated temporary table
Sharing, Cloning, Replication: External table
Can only be shared
Sharing, Cloning, Replication: Views
Secured Views can be shared and views ca be replicated.
Views can be cloned as part of a schema or db clone, but not alone
Sharing, Cloning, Replication: Materialized View
Can be shared and replicated
Can only be cloned as part of the schema or db clone, but not alone
Sharing, Cloning, Replication: Streams
Can only be cloned
Sharing, Cloning, Replication: Tasks
Can only be cloned
Sharing, Cloning, Replication: Pipes
None. Can only be cloned as part of a clone of a db or schema if it does not reference an internal stage
Sharing, Cloning, Replication: File Formats
Cloning, Replication
Sharing, Cloning, Replication: Internal Stages
None
Sharing, Cloning, Replication: External Stages
Cloning Only
Sharing, Cloning, Replication: Automatic Clustering
Cloning and Replication
Sharing, Cloning, Replication: Sequences
Cloning and Replication
Sharing, Cloning, Replication: Stored Procedures
Replication Only
Sharing, Cloning, Replications: UDFs
Sharing and Replication
Sharing, Cloning, Replications: Masking Policies
Replication Only
If you recreate a pipe using CREATE OR REPLACE PIPE command. What does happen to load history if the Snowpipe gets recreated?
The load history gets reset to empty
How many maximum columns (or expressions) are recommended for a cluster key?
3 to 4
Which stream type is supported for streams on the external table only?
Insert - Only
T/F Pattern matching using a regular expression is generally slow
True
File URL is ideal for
Custom applications that require access to unstructured data files
Which systems function can help find the overlap depth of a table’s micro-partitions?
SYSTEM$CLUSTERING_DEPTH
SYSTEM$CLUSTERING_INFORMATION
select * from t1 sample row(100); What would the above query return?
Return an entire table, including all rows in the table
What is the expiration period of a File URL?
It is permanent
Which command will delete all the data from a table, but keep the table
Truncate
T/F External Tables can be shared
True
A user’s default role is
The role a user gets to set to each time they login
Which SQL command determines whether a network policy is set on the account or for a specific user?
SHOW PARAMETERS
Select the type of function that can operate on a subset of rows within the set of input rows.
Window function
What are the supported file formats for data unloading in Snowflake?
JSON and Parquet only
What is created for each Kafka Topic
One pipe to ingest the data for each topic partition
One table for each topic
One internal stage to temp store data files for each topic
What types of views exist for snowflake
secure
materialized
standard
How can you load a file where the file’s metadata has expired
FORCE=TRUE
LOAD_UNCERTAIN_FILES=TRUE
Stored Procedure or UDF evaluates to a value
UDF
T/F You can use your username and password to login to the rest api
False
What does an ORGADMIN do
manages operations at the organization level
Can create accounts in the organization
Can view all accounts in the org, and all regions enabled
Can view usage information across the org
T/F A task can execute multiple sql statements
False
At what frequency does Snowflake rotate the object keys?
30 days
The major benefits of defining Clustering Keys are
To improve query performance
to help optimize table maintenance
