What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?
Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)
When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?
Which commands are restricted in owner's rights stored procedures? (Select TWO).
What are the least privileges needed to view and modify resource monitors? (Select TWO).
Which statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).
What metadata does Snowflake store for rows in micro-partitions? (Select TWO).
Which Snowflake table objects can be shared with other accounts? (Select TWO).
What transformations are supported when loading data into a table using the COPY INTO
command? (Select TWO).Which commands can only be executed using SnowSQL? (Select TWO).
Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
What is the default file size when unloading data from Snowflake using the COPY command?
What will prevent unauthorized access to a Snowflake account from an unknown source?
A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.
Which CREATE object statement will automatically assign the TABLE_A tag to a target object?
TESTED 06 Apr 2025
