cert Flashcards
Snowcd VS Snowsql
Snowcd is diag & troubleshoot their network
VS
Snowsql is a command line client for connecting to snowflake
Note: snowsql.conf file can be modified to customize options.
UDF VS SP
Within SP you can execute DB operations
UDFS you cannot access DB
Multiple UDFs may be called in a statement
only one with SP
how long does snowpipe keep load history
14 days
who can create/alter/drop network policy
security admin & accountadmin
is there a hard limit on number of shares
no
what is a share
Named DB objects that contains all the information required to share a DB like the object grants & consumer accounts details.
-tables -external tables -secure views -secure mvs -secure UDFs
When do you scale out vs scale up
You scale out when you have concurrent queries (MCW)
VS
You scale up when you have one large query
remote disk vs local disk
if snowflake cant fit operation in memory it spills to local storage then remote storage
DAC vs RBAC
DAC each object has an owner who can in turn grant privilege access to that object.
VS
RBAC access privilege is assigned to roles.
orgadmin vs accountadmin
orgadmin manages operations at the org level.
accountadmin, sysadmin, securityadmin are system defined roles. Top level role.
snowsight activity
snowsight is an upgrade from the classic console:
activity: query history, copy history, task history
what is snowpipe
-service that makes loading files process automated
-example load from s3 to snowflake DB
-no charge for snowpipe just pay for compute
*snowpipe loads new data typically within a minute notification is sent
*Its a severless feature
*Snowpipe load is stored in metadata of the pipe for 14 days used to prevent loading the same files in a table.
what are sequences
used to generate unique numbers across sessions. They can be used to generate unique values for PK or any column that requires a unique value.
Drivers snowflake supports
Go driver
jdbc
.net driver
node .js
ODBC driver
PHP PDO driver for snowflake
What is snowpark?
API to interact with data using:
-java
-scala
-python
no need for developers to move data out of snowflake to use language of their choice.
What is the object container hierarchy?
Organisation> account> DB> schema
search optimization speeds range or equality searches?
speeds only equality searches
what is a stored procedure?
Like functions a SP is created once and can be executed many times. A SP is created with a create procedure command and is executed using the call command.
What is a materialized view
A materialized view views results are stored, almost as though the results were a table. This allows faster access but requires storage and maintenance both which incur additional costs.
what are the two scaling policies
standard vs economy (conserves credits/warehouse starts if the system estimates theres enough load to keep cluster busy for at least 6 minutes.
what is a micro-partition size
50-500 mb (before compression)
What is a BUILD_SCOPED_FILE_URL
to create a URL file thats valid for only 24 hours.
What is the maximum number of days the property DATA_RETENTION_TIME_IN_DAYS can have?
90 days