Worksheetssnow10
Total questions: 12
Worksheet time: 12mins
How does Snowflake handle the data retention period for a table if a stream has not been consumed?
The data retention period is reduced to a minimum of 14 days
The data retention period is permanently extended for the table
The data retention period is temporarily extended to the stream’s offset
The data retention period is not affected by the stream consumption
In Snowflake, what allows users to perform recursive queries?
QUALIFY
LATERAL
PIVOT
CONNECT BY
Which languages are supported for writing in-line user-defined functions (UDFs) in Snowflake? (Choose two.)
JavaScript
SQL
Python
R
Java
What is the minimum role required to create and manage data shares?
ACCOUNTADMIN
SECURITYADMIN
SYSADMIN
USERADMIN
In Snowflake, if a pipe is paused, what happens to the incoming events?
All events are dropped
Events are retained in metadata for 14 days until the pipe is manually resumed
Events are retained until the pipe is automatically resumed
Events are stored indefinitely in metadata
Which are valid functions to check the data type in a VARIANT column? (Choose two.)
IS_GEOGRAPHY
IS_XML
IS_JSON
IS_NULL_VALUE
IS_DATE_VALUE
What are valid options for the FIELD_OPTIONALLY_ENCLOSED_BY function in Snowflake? (Choose two.)
'NULL'
NULL
NONE
'NONE'
Enclosed by apostrophe (')
What is the correct command to rename a database role from t1.r1 to r4
RENAME DATABASE ROLE
RENAME ROLE
RENAME DATABASE ROLE FROM t1.r1 TO r4
RENAME DATABASE ROLE FROM t1.r1 TO t4.r4
What are the required permissions to recover a dropped table in a data share? (Choose two, for both table and database levels)
Ownership permission on the table
CREATE TABLE permission at the database level
ALTER permission at the table level
DROP permission at the database level
What is the MOST EFFICIENT way to reduce queuing when there are many users repeatedly at the same time of day? (Choose two.)
Auto-scaling option
Maximized option
Scale out
Scale up
Economy option
If a Network Policy in Snowflake is changed while a user is already logged in, and their IP does not comply with the new policy, what happens?
The session is terminated automatically
The user can remain logged in until they log out
A warning is shown, but the session remains active
The new policy doesn’t apply until the next login
In Snowflake, what happens when the minimum retention time is changed at the ACCOUNT level?
The new retention time is applied immediately to all objects in all databases and schemas in the account, including already existing data
The new retention time only affects objects and data created or modified after the change
It only affects objects in schemas that have a retention time set lower than the new minimum established at the ACCOUNT level
It does not affect objects that already have a retention time defined at the schema or table level, but it will apply to those that inherit from the ACCOUNT setting
