snow10

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