Video deck Flashcards
How many days is the query history maintained in the history tab of the classic UI?
14
Which object does an external function make use of to hold security related information?
API integration
What is the recommended compressed file size when loading data into Snowflake?
100-250mb
How many databases objects can a data provider add to a SHARE object? Choose one correct value.
1
How many database objects can a data provider add to a SHARE object? Choose one correct value.
Unlimited
Which system function is called to retrieve clustering metadata for a column or columns?
system$clustering_information
How many accounts can a data consumer share a shared database with? Choose one correct value.
0 - Data consumers cannot re-share shared database objects.
Which symbols are used when referencing a user stage via SQL? Choose one correct value.
@~
Which symbols are used when referencing a table stage via SQL? Choose one correct value.
@%
The account usage share contains a database called SNOWFLAKE. The views in this database are used to provide fine-grained metrics at the account and object level. What is the maximum number of months data in these views available for? Choose one correct value.
12 - Certain account usage views provide historical usage metrics. The retention period for these views is 1 year.
The COPY INTO <table> statement does NOT require a virtual warehouse to run. True or false?
False
Which system-defined role is it recommended to assign custom roles to? Choose one correct value.
If custom roles are not assigned to the SYSADMIN role, system admins will not be able to manage the objects owned by the custom role.
Every securable object is owned by a single role. True or false?
True
What is the default value for the table property DATA_RETENTION_TIME_IN_DAYS for an account on the enterprise edition of Snowflake?
The default value for DATA_RETENTION_TIME_IN_DAYS is 1 for all editions of Snowflake.
If the query profile indicates queries are regularly spilling to remote storage what are the recommended solutions?
Increase the size of the Virtual Warehouse.
Process data in smaller batches.
External tables can be cloned. True or false?
False
If enabled, periodic rekeying happens every ___ months
12 - If periodic rekeying is enabled, then when the retired encryption key for a table is older than one year, Snowflake automatically creates a new encryption key and re-encrypts all data previously protected by the retired key using the new key. The new key is used to decrypt the table data going forward.
A schema cannot be cloned. True or false?
False
Fail-safe is available for external tables. True or false?
False - It is only available for permanent table types
What’s the maximum number of days a user could set the table property DATA_RETENTION_TIME_IN_DAYS to for a transient table on a business critical edition Snowflake account?
1 - The maximum DATA_RETENTION_TIME_IN_DAYS is 0 or 1 for temporary and transient tables regardless of the edition of Snowflake.
Which types of notation are used to traverse semi-structured data natively in Snowflake? Select all that apply.
bracket and dot
Which is the most accurate description of the Snowflake Partner Connect?
The Snowflake Partner Connect is a service which expedites the process of getting up and running with selected third-party tools.
What is the purpose of the VALIDATE function? Choose one correct value.
Allows a user to view all errors encountered during a previous COPY INTO execution.
When is a table stage not appropriate to use for data loading?
When loading into multiple tables
